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]
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
