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 vote120 views1 answer
Sql cmd no truncate
SQL
0 vote103 views5 answers
Linq cheat sheet
SQL
0 vote94 views1 answer
Stuff in sql server
SQL
0 vote109 views1 answer
Manage Database in MySQL
SQL
0 vote116 views1 answer
Mysql regex select
SQL
0 vote102 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote93 views1 answer
How to delete record sql delphi
SQL
0 vote87 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
16 votes104 views2 answers
Mysql date between two dates
SQL
1 vote105 views1 answer
Mysql find most common value
SQL