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 vote178 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote264 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote237 views1 answer
Table structure in sql
SQL
6 votes268 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
14 votes195 views3 answers
Trim sql
SQL
0 vote194 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote191 views1 answer
Postgresql comandos basicos
SQL
0 vote197 views1 answer
Mysql date time string format for marshmellow field schema
SQL
1 vote157 views1 answer
Database run
SQL
0 vote188 views1 answer
Postgre admin slow
SQL