Auto Increment Issue - Incrementing By 10

Question

I'm getting a strange issue on my database.

All auto increment fields of my database (all tables) are getting increment by 10.

Previously it was working fine (increment by 1). And now its started to increment by 10.

Table 1

table 1

Another table

table 2

See:: http://stackoverflow.com/questions/993800/mysql-table-incrementing-by-10-for-some-reason and http://stackoverflow.com/questions/206751/mysql-autoincrement-column-jumps-by-10-why — Sudhir Bastakoti, Nov 14 '13 at 06:05

score 3 · Accepted Answer · answered Nov 14 '13 at 06:04

3

Set the auto_increment_increment system variable to 1.

SET @@auto_increment_increment=1
SET GLOBAL auto_increment_increment=1;

answered Nov 14 '13 at 06:04

juergen d

score 0 · Answer 2 · answered Nov 14 '13 at 06:09

0

It's Something like that :

SET @@auto_increment_increment=1;

or for specific table :

ALTER TABLE users AUTO_INCREMENT =1;

Or you can refer w3school

answered Nov 14 '13 at 06:09

Java Curious ღ

score 0 · Answer 3 · answered Nov 14 '13 at 11:07

0

Yes you may set the auto_increment_increment variable to 1

SET @@auto_increment_increment=1

SET GLOBAL auto_increment_increment=1;

in mysql it will work definitely.

answered Nov 14 '13 at 11:07

Jitendra Pareek

3 Answers3