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 vote386 views1 answer
GROUP BY postgres
SQL
7 votes314 views1 answer
Mysql load data infile csv
SQL
0 vote314 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote349 views3 answers
Insert or ignore postgres
SQL
2 votes332 views1 answer
Postgresql add entry to table
SQL
3 votes378 views2 answers
Sql add year to date
SQL
-1 vote363 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
3 votes366 views4 answers
Ubuntu stop mysql
SQL
0 vote363 views1 answer
Postgres change the name of schema
SQL
0 vote349 views1 answer
Sql DATE = GETDATE()
SQL