Phpmyadmin no longer allows me to set auto_increment

Question

Previously, I could set the value of auto_increment in phpmyadmin-> table-> operations, but I no longer see it in this field:

http://puu.sh/4dhf4.png

It used to be right there, yes, my table has an auto_increment field. I am using phpmyadmin 4.4.0 and I have already tried switching from InnoDB to MyISAM. I registered with phpmyadmin using root.

Answer 1

I'm not sure why they removed this function, but the way to make it "old school" is to click on the SQL tab and then run the following MySQL command:

ALTER TABLE `sessions` auto_increment = 12345 

This will set the auto increment counter to 12345 (or one greater than the highest value already in the "sessions" table).

Answer 2

The table does not have the auto_increment option, its table columns for which you can assign the auto_increment option. The option is called a_i

Answer 3

This is strange. I just checked a few recent versions and am not experiencing this problem. The only time I can make it not display this field if there is no auto_increment. Can you post a screenshot or SQL dump of the database structure to try to play it?

Answer 4

If you use phpMyAdmin, you can click the name of your table, and then click the "structure" tab. under additional functions you can put autorun. If this does not work, make sure that the user you register in your table has permission to make such a change. A query to create an automatic field increment will be something like.

CREATE TABLE Employee (ID int NULL AUTO_INCREMENT, Name varchar (255));

In this case, the field identifier will be automatically loaded