How to Jump into auto increment values

[maheswaran]

Hi,
I have used auto increment for inserting value id. Now i want to jump this for example i want insert the values 200,201 or 200,202,204 instead of 2,3,4..

How can i jump or swap....

[ronverdonk]

Hi,
I have used auto increment for inserting value id. Now i want to jump this for example i want insert the values 200,201 or 200,202,204 instead of 2,3,4..
How can i jump or swap....

Then look at the standard MySQL documentation on how to do this http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

Ronald

[Atli]

Just to have the answer in this thread as well, let me quote the juicy part of Ronald's link:

To change the value of the AUTO_INCREMENT counter to be used for new rows, do this:

ALTER TABLE t2 AUTO_INCREMENT = value;

[ronverdonk]

Just to have the answer in this thread as well, let me quote the juicy part of Ronald's link:

Yeah, but I prefer people to get a bit more familiar with the standard documentation and look for their answers in there themselves.

Sometimes I feel like performing exegesis on the available online user books, especially PHP and MySQL.

Ronald