On Tue, 24 May 2005 [EMAIL PROTECTED] wrote:
>Is there a better way to reset the auto_increment in a table, basically
>there are several million rows in the database and the field that is
>auto_increment is very large now and I don't want to exceed the limit of
>the field description so I want to
Is there a better way to reset the auto_increment in a table, basically
there are several million rows in the database and the field that is
auto_increment is very large now and I don't want to exceed the limit of
the field description so I want to renumber all the rows starting at 1
again.
Wha
At 2:31 PM +0100 8/21/01, Brian Leyland wrote:
>Hello,
>
>I need to reset the auto increment value on a database.
>
>Can anyone help.
>
>
>Thanks
>
>Brian
If it's a MyISAM table and you mean that you want to reset the sequence
so that MySQL will next use the smallest currently unused value, do th
Hello,
I need to reset the auto increment value on a database.
Can anyone help.
Thanks
Brian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list a
