Add Primary Key To Table Mysql. MySQL add primary key to existing empty table. It is easy to create a MySQL table from the mysql prompt.
In this tutorial we are going to select the gallery database which contains the gallery table. This is an article which is created to change a table exist in MySQL Database Server. Alter table goods add column id int10 unsigned primary KEY AUTO_INCREMENT.
The query to create a table.
The PersonID column in the Persons table is the PRIMARY KEY in the Persons table. ALTER TABLE teachers DROP COLUMN id ADD COLUMN id INT NOT NULL AUTO_INCREMENT PRIMARY KEY. After adding the column you can always add the primary key. First of all We have to create a table in MySQL database.
