no this is not the point ! if I do this, the next auto_increment is still 10720 i can do what I want however the is defined long unsigned unique auto_increment, what happens is in t1 the value is set to 10720 in t2 the next value ist set to 10721 while the next record in t1 gets 10721.
it seems like the values in this field are unique OVER the whole database. very strange to me... ralph_def...@yahoo.de "Jerry Wilborn" <jerrywilb...@gmail.com> wrote in message news:3f4628f60908091202s67205256o222f22a0bfb61...@mail.gmail.com... > ALTER TABLE T1 AUTO_INCREMENT=1; > It's likely that you dropped every record and expected the auto_increment to > reset. > > Jerry Wilborn > jerrywilb...@gmail.com > > > On Sun, Aug 9, 2009 at 1:17 PM, Ralph Deffke <ralph_def...@yahoo.de> 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_def...@yahoo.de > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php