Dave's Brain

Browse - computer tips - mysql add primary key to 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;

Add a comment

Sign in to add a comment