← Back to team overview

drizzle-discuss team mailing list archive

Re: tables must have a primary key


On Wed, 7 Apr 2010 15:56:54 +0200, Arjen Lentz <arjen@xxxxxxxxxxxxx> wrote:
> Please make a clear distinction in your head between PK and auto-inc.
> We're here agreeing that all tables should have a PK.
> They may or may not have an auto-inc field; some may just have an id  
> which is a fk from another table's auto-inc, or a composite of  
> multiple tables.

yep. My brain skipped a step in the thinking along the lines of a table
where someone just adds a auto_inc pkey to stop the database complaining

Stewart Smith