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

12 votes156 views1 answer
Env var for setting password for root user mysql docker hub
SQL
5 votes159 views2 answers
Oracle show procedures
SQL
3 votes179 views2 answers
@sqlresultsetmapping
SQL
0 vote133 views1 answer
Postgresql get current user name
SQL
0 vote148 views1 answer
Mysql query problems and solutions
SQL
2 votes160 views1 answer
Oracle percentage
SQL
1 vote155 views1 answer
Sql drop schema
SQL
12 votes138 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote139 views1 answer
Vowels in sql
SQL
0 vote142 views1 answer
Java mysql date format
SQL