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

14 votes364 views4 answers
Online sql compiler
SQL
11 votes363 views1 answer
Mysql order by two columns priority
SQL
10 votes358 views1 answer
Query to find object dependencies in oracle
SQL
0 vote354 views2 answers
Sqlite unique
SQL
7 votes335 views1 answer
Grant schema permissions postgres
SQL
0 vote359 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote365 views4 answers
Mysql on kubernetes
SQL
4 votes337 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
10 votes357 views1 answer
Oracle all_dependencies
SQL
5 votes352 views3 answers
Day of week postgresql
SQL