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
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
