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 vote238 views1 answer
What is between keyword used for
SQL
-1 vote240 views1 answer
Extract Data from SQL Server into XML Format
SQL
3 votes217 views1 answer
Make a field auto_increment mysql
SQL
-1 vote190 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote234 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote222 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote219 views1 answer
Mysql installer no packages found
SQL
2 votes227 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
5 votes231 views1 answer
Sql check if date is between 2 dates
SQL
0 vote228 views1 answer
Oracle query archivemode
SQL