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 vote290 views1 answer
Sql drop procedure if exists
SQL
16 votes277 views6 answers
Mysql find and replace
SQL
1 vote259 views1 answer
Firebase bigquery cloud message
SQL
4 votes265 views1 answer
Mysql insert from local csv
SQL
0 vote278 views1 answer
Dump db only triggers mysql
SQL
0 vote275 views1 answer
Update view sql
SQL
12 votes285 views2 answers
Update column data type postgres
SQL
31 votes268 views3 answers
Sql count(*)
SQL
1 vote275 views1 answer
Mysql best tutorial for beginners
SQL
1 vote307 views1 answer
Tsql replace value in json
SQL