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 vote285 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote294 views1 answer
Désinstaller postgresql linux
SQL
4 votes295 views1 answer
Oracle session date format
SQL
0 vote266 views2 answers
Avg() sql
SQL
0 vote286 views1 answer
How to query all tables mysql at the same time
SQL
7 votes347 views3 answers
Sql server check if temp table exists
SQL
0 vote302 views1 answer
How to Remove milliseconds from Date time
SQL
2 votes281 views1 answer
Sql ignore accents
SQL
7 votes267 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote333 views1 answer
How to fetch data from database in sql
SQL