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

8 votes127 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote149 views1 answer
Mysql remove bad character from all fields
SQL
0 vote143 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote136 views1 answer
Linebreak sql
SQL
0 vote211 views1 answer
Add user mysql wordpress
SQL
3 votes94 views4 answers
Mysql delete duplicate rows
SQL
0 vote150 views2 answers
Sql query print strings and int
SQL
11 votes133 views1 answer
Sql query to find duplicates in column
SQL
3 votes157 views3 answers
Sql current year
SQL
0 vote165 views1 answer
Eliminate zero from integer mysql
SQL