I used to be able to set the auto_increment value in phpmyadmin->table->operations, but I no longer see it in this box:
http://puu.sh/4dhf4.png
It used to be right under there, yes my table has an auto_increment field. I'm using phpmyadmin 4.4.0, and I already tried switching from InnoDB to MyISAM. I'm logged into phpmyadmin with root.
I'm not sure why they removed this feature, but the way to do this "old school" is to click on the SQL tab and then run the following MySQL command:
ALTER TABLE `sessions` auto_increment = 12345
This would set the auto increment counter to 12345 (or to one more than the highest value already in the 'sessions' table).
I table doens't have an auto_increment option, its the table columns that you can asign the auto_increment option to. The option is called a_i
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With