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

6 votes331 views2 answers
Sql display max value
SQL
0 vote333 views1 answer
Mysql conf.d exampel
SQL
0 vote340 views1 answer
How get data from database if id not found then search another column
SQL
4 votes334 views1 answer
Is there any command to change postgres password
SQL
11 votes324 views2 answers
MySQL DISTINCT
SQL
1 vote324 views1 answer
Sql delete all values in a column
SQL
20 votes328 views4 answers
Reset auto increment in MySQL
SQL
0 vote366 views1 answer
Mysql value ends with
SQL
-1 vote354 views1 answer
Phinehas Psalm 106
SQL
0 vote341 views2 answers
Tsql row number
SQL