I believe this thread (from only three days ago) will answer your question. http://lists.mysql.com/list.php?1:mss:141551:200306:kkmidpclnclgkpjgpgkd
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Dylan Pham" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 03 June, 2003 13:27 Subject: AUTO_INCREMENT Hi, I am new and am wodering if anyone can point out how to make AUTO_INCREMENT readjust the numbers so that when you delete a row it will go back to using the next number after the last row in the table? Thank you. Hai __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]