Re: Resetting Auto Increment Count

2001-08-21 Thread Paul DuBois
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

Resetting Auto Increment Count

2001-08-21 Thread Brian Leyland
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