mysql - How to add AUTO_INCREMENT to an existing column?

Question

How do I add auto_increment to an existing column of a MySQL table?

Answer 1

I think you want to MODIFY the column as described for the ALTER TABLE command. It might be something like this:

ALTER TABLE users MODIFY id INTEGER NOT NULL AUTO_INCREMENT;

Before running above ensure that id column has a Primary index.