How can I add a primary key to a MySQL table?

Computer Tips - How can I add a primary key to a MySQL table?

Date: 2010mar12 Q. How can I 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;