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.
Subject
Written By
Posted
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.