ALTER TABLE T1 AUTO_INCREMENT=1; It's likely that you dropped every record and expected the auto_increment to reset. Jerry Wilborn jerrywilborn@xxxxxxxxx On Sun, Aug 9, 2009 at 1:17 PM, Ralph Deffke <ralph_deffke@xxxxxxxx> wrote: > Hi all, > > I'm facing the fact that it seems that auto_increment fields in a table not > start at 1 like it was in earlier versions even if I install mySQL brand > new > creating all tables new. it seems to me that auto_increments handling has > changed to older version. is somebody out there who can give me a quick > background about auto_increment and how and if I can control the behavior > of > mySQL about them. > > ralph_deffke@xxxxxxxx > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
