hi you can reset the counter yourself with the following sql statement
ALTER TABLE tbl_name AUTO_INCREMENT = 1; best regards benny ----- Original Message ----- From: "Dylan Pham" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 03, 2003 7:27 PM 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]