Mysql change primary key

ALTER TABLE tableName MODIFY COLUMN id INT; /* First you should drop auto increment */
ALTER TABLE tableName DROP PRIMARY KEY; /* Dop primary key */
ALTER TABLE tableName ADD PRIMARY KEY (new_id); /* Set primary key to the new column */
ALTER TABLE tableName MODIFY COLUMN new_id INT AUTO_INCREMENT; /* Set auto increment to the new primary key */

Similar codes

0 vote140 views1 answer
Oracle sql log to console
SQL
0 vote137 views2 answers
Sql count number of rows after group by
SQL
8 votes158 views1 answer
Script to add datafile to tablespace
SQL
3 votes148 views1 answer
Oracle list privileges
SQL
0 vote313 views1 answer
The package java.sql is not accessible
SQL
1 vote106 views1 answer
Oracle boolean to varchar
SQL
7 votes143 views1 answer
Sql server convert string to date
SQL
0 vote156 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
25 votes175 views1 answer
How to update an attribute in MySQL
SQL
0 vote150 views1 answer
Cast as decimal postgresql
SQL