mysql how do I change the column id from varchars to ints and autoincreasing?

Question

How do I make the change of the column ID in the table to ints and auto-increment through phpmyadmin?

Thanks

Answer 1

Try this:

ALTER TABLE your_table
CHANGE ID ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY

Answer 2

If there is no primary key, try this statement -

ALTER TABLE table
  CHANGE COLUMN id id INT(11) NOT NULL AUTO_INCREMENT,
  ADD PRIMARY KEY (id);

Otherwise, you can run a script like this -

ALTER TABLE table
  CHANGE COLUMN id id INT(11) NOT NULL AUTO_INCREMENT;

Answer 3

Do the following steps :

1) Make the datatype of columns for autoincrement as BIGINT 2) Make the same column as primary key. 3) Then add the auto inrement option as shown in the image AUTO INCREMENT