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

4 votes307 views2 answers
Oracle unlock account
SQL
2 votes301 views2 answers
Storing timezones in postgres
SQL
0 vote287 views1 answer
Postgresql function ROUND
SQL
0 vote312 views1 answer
Table user postgres
SQL
0 vote279 views1 answer
Double in sql server example
SQL
0 vote286 views1 answer
Oracle execute package dblink
SQL
0 vote267 views1 answer
Mysql update sum same table
SQL
0 vote271 views1 answer
Raiserror nowait sql server
SQL
1 vote265 views1 answer
Mysql date diff in seconds
SQL
0 vote292 views1 answer
Flask sqlalchemy session delete
SQL