How to change the primary key in mysql

Mysql method to change the primary key: First execute the [alter table table name drop primary key;] command to delete the primary key; then execute the [alter table table name add primary key(id)] command to re-add the primary key.

Specific method:

(Recommended tutorial: mysql video tutorial)

For example, we want Delete the original primary key constraints of the coal_3 table and execute the command:

alter table coal_3 drop primary key;

It should be noted that if the primary key is set to auto-increment, you need to remove the auto-increment first and then delete the primary key.

(Related tutorial recommendations: mysql tutorial)

Then re-add the primary key, the command is as follows:

alter table coal_3 add primary key(id)

The above is the detailed content of How to change the primary key in mysql. For more information, please follow other related articles on the PHP Chinese website!