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 vote320 views1 answer
Drop unique
SQL
6 votes328 views2 answers
Where clause in sql
SQL
-1 vote310 views1 answer
Sql getdate date only
SQL
0 vote352 views1 answer
Updating database in sql
SQL
0 vote316 views1 answer
Sql grant select only
SQL
0 vote334 views2 answers
Postgres show current role
SQL
2 votes363 views2 answers
Create table mysql integer NOT null
SQL
0 vote317 views1 answer
Oracle create package specification
SQL
3 votes355 views2 answers
Oracle sql first day of month
SQL
13 votes304 views2 answers
Display users in mysql
SQL