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

1 vote129 views2 answers
Sql drop multiple columns if exists
SQL
14 votes120 views4 answers
Sql compiler
SQL
0 vote159 views1 answer
Postgres extract number from string
SQL
0 vote120 views1 answer
Postgres enumerated type
SQL
0 vote106 views3 answers
Joins and views sql
SQL
9 votes124 views4 answers
Mysql set id auto increment
SQL
1 vote134 views1 answer
Create index concurrently postgres
SQL
0 vote119 views1 answer
Mysql workbench format date
SQL
0 vote109 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote112 views1 answer
How to find symmetric pairs in sql
SQL