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

4 votes151 views2 answers
Sql vs mysql
SQL
14 votes172 views4 answers
Online sql compiler
SQL
0 vote148 views6 answers
Unique key in sql
SQL
0 vote169 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote167 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote244 views1 answer
Alter table name including schema
SQL
0 vote196 views1 answer
Mariadb disable foreign key checks
SQL
0 vote170 views1 answer
Disable database droping sql
SQL
0 vote164 views1 answer
Create table in dbms cmds
SQL
1 vote152 views1 answer
Create another table from existing table sql oracle
SQL