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 vote212 views1 answer
Drop view in mysql
SQL
0 vote187 views2 answers
Mysql unique two columns
SQL
0 vote199 views1 answer
Mssql disable foreign key constraint
SQL
12 votes222 views1 answer
Psql drop column
SQL
0 vote268 views1 answer
Sql server sleep
SQL
1 vote274 views1 answer
Cannot drop database because it is currently in use
SQL
1 vote200 views1 answer
Oracle grant on all tables in schema
SQL
0 vote166 views1 answer
Create duplicate table postgres
SQL
1 vote214 views2 answers
Mysql between
SQL
1 vote178 views1 answer
Oracle lock user
SQL