Hello Miroslav, Tuesday, July 15, 2003, 3:10:10 PM, you wrote:
Easiest way to do what you want is to make this: 1.SHOW CREATE TABLE TableName and copy SQL 2. DROP TABLE TableName 3. CREATE TABLE - with SQL copied in 1. MI> Hi, MI> 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. MI> thanks -- Best regards, Krasimir_Slaveykov mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]