Please check the history on this list. There are numerous answers to this problem.
Cheers /rudy -----Original Message----- From: Miroslav I. [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 14:10 To: [EMAIL PROTECTED] Subject: auto number primary key - restarting Hi, is there an SQL command for making a primary key (auto number key) to start numbering from beginning after deleting all the records from the table. thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]