Dave's Brain

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;

Add a comment

Sign in to add a comment
Copyright © 2008-2017, dave - Code samples on Dave's Brain is licensed under the Creative Commons Attribution 2.5 License. However other material, including English text has all rights reserved.