delete all records by this command: TRUNCATE TABLE `mytable`;
----- Original Message ----- From: "Miroslav I." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 15, 2003 8:10 AM 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]
