Auto increment mysql server for windows

I need a way to keep autoincrement counter between mysql service restart. Mysql auto increment primary key increases by 10 stack overflow. This occurs because the order in which the rows are numbered depends on the specific storage engine used for the table and the order in which the rows were inserted. Basically this is a bug in mysql that causes the problem but a work around is simple.

Auto increment is a function that operates on numeric data types. Mysql autoincrement counter resetting after server restart. Checked the followingservice is running windows firewall is offantivirus is minimal, so no impact on mysql password is correct, it is passed in the mysql client option so no fat finger. Mysql workbench auto increment disabled stack overflow. How to create auto increment column in postgresql use. Obtaining autoincrement values mysql developer zone. How to add the auto increment setting to a mysql table column through phpmyadmin. Hash join and explain analyze 1 posts edwin desouza. This article is a comprehensive guide on how to use auto increment in sql with examples in sql server, mysql, ms access, oracle and. By running alter table it happens something i see altered rows, but value does not fix, so after refresh it comes back to null. Is it a bug or i need to enable this some how in options. I know that in mysql at the command line i can reset a tables autoincrement field to 1 with this.