Under mysql 5.0.18 you can do something like: // get the current value of the auto_increment counter mysql> select @@auto_increment_offset; +-------------------------+ | @@auto_increment_offset | +-------------------------+ | 1105 | +-------------------------+ 1 row in set (0.00 sec)
// set it to your required value mysql> set @@auto_increment_offset = 201; Query OK, 0 rows affected (0.01 sec) // make sure it is set to what you want it to be mysql> select @@auto_increment_offset; +-------------------------+ | @@auto_increment_offset | +-------------------------+ | 201 | +-------------------------+ 1 row in set (0.02 sec) mysql> HTH Keith Roberts In theory, theory and practice are the same; in practice they are not. On Fri, 23 Jun 2006, Tom Ray [Lists] wrote: > To: mysql@lists.mysql.com > From: "Tom Ray [Lists]" <[EMAIL PROTECTED]> > Subject: Autoindexing > > Hey, I have a really simple question (I hope)..I have a database that has > a field in it that autoindexes the number. I screwed up and imported a > bunch of wrong data. Up to row 200 it's right, beyond that it was wrong so > I had delete it all. The problem now is the autoindexing is set to 1105, I > want to change it so the next insert gets a number of 201 not 1105. > > I've tried to change it via phpMyAdmin but it keeps going back to 1105. Is > there anyway I can do this? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
