Browse - 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;