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 vote162 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
2 votes172 views1 answer
Delete all value query
SQL
1 vote171 views1 answer
Mysql query where in select
SQL
3 votes179 views5 answers
Duplicate table sql
SQL
1 vote186 views1 answer
Window function mysql
SQL
16 votes160 views2 answers
Gremove folder from git
SQL
1 vote186 views1 answer
Quit mysql
SQL
0 vote181 views1 answer
How to print some string in mysql
SQL
7 votes204 views1 answer
Oracle alter sequence restart start with
SQL
1 vote124 views1 answer
Oracle compile schema
SQL