TRUNCATE TABLE would work too. That would automatically remove all rows
as well.
Chris
mel list_php wrote:
Hi,
I think you are looking for something like that:
ALTER TABLE .... auto_increment=1 (or whatever value you want)
melanie
From: Mário Gamito <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Resetiing indexes
Date: Thu, 24 Mar 2005 11:41:30 +0000
Hi,
I'm using MySQL on a project, and during the development stage, the
number of the (auto incrmenting) indexes went increasing.
Now that the deed is done, how can i "reset" them back to 1, without
having to throw away the database and rebuilding it from scratch ?
Any help would be apreciated.
Warm Regards,
Mário Gamito
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]