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 [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php