On Wednesday, 26 June 2013 at 18:07, Tedd Sperling wrote: > Hi gang: > > I have a client where their next auto-increment number just jumped from 2300 > to 1000000000 for reasons not understood. They want it set back. > > Options such as dropping the primary key and rebuilding the index is NOT > possible -- this is a relational table thing. > > So, is there a way (programmatically) to set the next number in an > auto-increment? > > Something like: > > alter table abc auto_increment = 2301; >
ALTER TABLE tbl AUTO_INCREMENT = 2301; -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
