MySQL Forums
Forum List  »  Newbie

Re: set auto_increment step
Posted by: Barrett
Date: June 29, 2009 12:30PM

So, is there not a way to set the increment at the table level, rather than at the system level, as can be done with the offset?

The documentation for the system variables says
"It is not possible to confine the effects of these two variables to a single table, and thus they do not take the place of the sequences offered by some other database management systems; these variables control the behavior of all AUTO_INCREMENT columns in all tables on the MySQL server"

However, setting the offset using "alter table junk auto_increment = 100" does set the offset to 100 for only that table.

Options: ReplyQuote


Subject
Written By
Posted
June 29, 2009 07:14AM
June 29, 2009 11:35AM
Re: set auto_increment step
June 29, 2009 12:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.