mysql@lists.mysql.com
Subject: Resetiing indexes
Date: Thu, 24 Mar 2005 11:41:30 +
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
hav
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 +
Hi,
I'm using MySQL on a p
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.
