How about: ALTER table auto_increment=0 > -----Original Message----- > From: Claudiu [mailto:[EMAIL PROTECTED]] > I wish it was that simple... > No.. It doesn't work this way... > > On Tue, 12 Mar 2002, Rick Emery wrote: > > > your query is: DELETE FROM mytable; > > > > -----Original Message----- > > From: Claudiu [mailto:[EMAIL PROTECTED]]
> > My problem is that the auto_increment field won't reset to 0 after > > deleting all of tha data, but continue incrementing from > where it left. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php