Answer the question
In order to leave comments, you need to log in
Does MySQL database increment by 10?
Good evening. Since recently, in all tables of all MySQL databases, values have been incremented by 10.
Moreover, the first record has a value of 7. Then comes 17, 27, 37 and so on.
How can this be fixed?
Answer the question
In order to leave comments, you need to log in
If mysql has a global variable setting (auto_increment_increment, auto_increment_offset), you can use session variables. Immediately after connecting to the database, run two queries:
SET auto_increment_increment = 1;
SET auto_increment_offset = 1;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question