How can I use auto increment value in primary key in the existing table?

Question

SQL

Answer 1

Thanks Xyenia.

Answer 2

Take a look at the sql syntax here:

https://www.w3schools.com/sql/sql_autoincrement.asp

Also, if you are using phpMyAdmin, through the interface, you can select auto increment for the primary key field.

I think 🤔 the field type has to be numerical for AI (auto increment)