Hi I'm relatively new to MySQL though I familiar to other simple databases. I have been reading the manual but not doing well understanding the function of auto_increment and Premier Key. Lets say I have a table with a few columns. One of them is an ID with auto_increment. It has 1000 rows. If I delete row #500 to #599 (total of 100), will the MySQL update the ID value for row #600 to #1000, or will it stay as it was? If it stays as it was, and afterwards when I add a row (or record), will it continue from row #1001 or will it use the value from #500 to #599? What is the Primary Key used for and how does it work? Do I need it if I have a row ID like mentioned above? Regards, Sumarlidi Einar Dadason SED - Graphic Design ------------------------------------------ Phone: (+354) 4615501 Mobile: (+354) 8960376 Fax: (+354) 4615503 E-mail: [EMAIL PROTECTED] Homepage: www.sed.is <- New Homepage! ------------------------------------------ --------------------------------------------------------------------- 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
