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 vote186 views1 answer
Sql #region
SQL
13 votes185 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote155 views1 answer
Duplicate foreign key constraint name
SQL
13 votes181 views3 answers
Insert mysql ifile nto database
SQL
5 votes167 views1 answer
How to get all dates in a month in oracle
SQL
1 vote183 views1 answer
Set statiscis on in ssms
SQL
0 vote157 views1 answer
CREATE MULTIPLE FK
SQL
2 votes216 views1 answer
Sqlite3 show columns name
SQL
0 vote176 views1 answer
How to connect to mysql in ef 6
SQL
0 vote185 views2 answers
Compound operator in sql
SQL