Search code examples
mysqlauto-increment

mysql issue with auto-increment

I am facing a problem with mysql auto-increment , actually it is not creating any problem. I am just confused why mysql auto-increment field getting even data. Evertytime a new entry its creating like this 2,4,6,8,10....... insteed of 1,2,3,4,5,6.......

Have you know about this or facing situation like this.

Solution

  • SHOW VARIABLES LIKE 'auto_inc%';

    use it to check autoincrement and set it to proper values with 

    SET @@auto_increment_increment=1;

    It will set auto increment to 1