D
D
Dmitry Gulyaev2013-01-28 18:19:38
MySQL
Dmitry Gulyaev, 2013-01-28 18:19:38

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

2 answer(s)
D
Dmitry T., 2013-01-28
@Didget

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;

B
betal, 2013-01-28
@betal

In mysql config
for debian systems file /etc/mysql/my.conf
There parameters
auto_increment_increment
auto_increment_offset

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question