List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 17 2002 3:38am
Subject:Re: auto increment as primary key
View as plain text  
In the last episode (Aug 16), Fr. Robert Bower said:
> Is it a good idea to use an auto increment field as a primary key in mysql?
> I know in some products like paradox it is a bad idea because of possible
> corruption problems down the road?

If you get corrupt databases, don't blame the primary key.  Blame the
databse software.  :)

You almost always want your autoincrement field to be your primary key,
no matter what database you're using.

-- 
	Dan Nelson
	dnelson@stripped
Thread
auto increment as primary keyFr. Robert Bower17 Aug
  • Re: auto increment as primary keyDavid Lloyd17 Aug
  • Re: auto increment as primary keyDan Nelson17 Aug