mysql autoincrement is not sequential in innodb
auto-increment, mysql
Solution
don't know about codeignitor and specifics of transactions, but i do know that "catched fails" in queries (like `insert ignore`) have the effect of NOT inserting, but DO increment the auto_increment. Look for your answer here. And for the rest don't bother 'fixing' this.
Problem
Mysql autoincrmenting is not sequential. when i was trying to upload csv bulk data it's skipping some of the auto increment id The auto increment id is not sequential The db engine is innodb & id is auto increment example ``` id color 1 red 2 blue 3 green 4 orange 9 pink 10 white 11 black 16 gray 17 brown ``` The id is not sequential.