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

35 votes121 views6 answers
Postgres
SQL
0 vote124 views1 answer
Ajax error exception handeling
SQL
0 vote123 views1 answer
Get number of rows in every table mysql
SQL
8 votes125 views1 answer
Database backup in mysql server recovery
SQL
0 vote126 views2 answers
How to relationship query two different tables in MySQL
SQL
15 votes113 views3 answers
Create table with primary key auto increment in sql
SQL
4 votes111 views2 answers
Sql table
SQL
0 vote117 views1 answer
Sql select column name like from multiple tables
SQL
3 votes132 views6 answers
Jwt laravel
SQL
3 votes111 views1 answer
Oracle revoke
SQL