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 votes392 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
22 votes320 views6 answers
Create sql table
SQL
0 vote350 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
19 votes338 views5 answers
Mysql between date range
SQL
1 vote353 views2 answers
Sql split string by space
SQL
4 votes382 views2 answers
Postgresql float data type
SQL
1 vote368 views3 answers
Date_add mysql
SQL
58 votes564 views4 answers
Mysql drop column
SQL
1 vote337 views1 answer
Mysql view current queries
SQL
0 vote379 views1 answer
Mysql backup query
SQL