My SQL AUto Increment
I have 2 different MySQL servers. One is 5.6.12 the other 5.5.25a.
In the 5.5 version server I can do this:
ALTER TABLE AUTO_INCREMENT = 100;
ALTER TABLE AUTO_INCREMENT = 50;
The 5.6 version only allows me to change the auto_increment to a higher
value than auto_increment is in that moment.
Of course I'm not trying to change the value to a lower value than the
record that has the maximum value.
Both MySQL servers are InnoDB
I need to use that commen in the newest version
Any clue?
No comments:
Post a Comment