Or drop and recreate the table (that's actually what truncate is doing)
/rudy
-----Original Message-----
From: Miguel Perez [mailto:ironmitss@stripped]
Sent: woensdag 9 juli 2003 20:08
To: mysql@stripped
Subject: RESETTING AUTO_INCREMENT
Hi everyone:
Does anyone know how to reset the auto_increment value of certain table.
Any ideas or sugestions
Greetings in advance
_________________________________________________________________
Únete al mayor servicio mundial de correo electrónico:
http://www.hotmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1