> 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.
Actually, the easiest way to do this (assuming *all* records have been deleted) is: UPDATE table_name SET auto_increment_field = 0; Replace '0' with any number that you want to start with. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
