Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

phpmyadmin is no longer letting me set auto_increment value

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.

like image 950
SuperBeast Avatar asked Dec 11 '22 11:12

SuperBeast


2 Answers

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).

like image 50
underdog Avatar answered Feb 24 '23 15:02

underdog


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

like image 44
Terry Avatar answered Feb 24 '23 15:02

Terry