mysql: How to add a primary key to a MySQL table?

Computer Tips - mysql: How to add a primary key to a MySQL table?

Date: 2010mar12 Q. mysql: How to add a primary key to a MySQL table? A. Use this SQL:

ALTER TABLE mytable ADD COLUMN id INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;