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

2 votes168 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote126 views1 answer
CREATE MULTIPLE FK
SQL
1 vote155 views1 answer
Convert to hexadecimal sql
SQL
0 vote147 views1 answer
Sqlite3 update select
SQL
3 votes143 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
2 votes187 views1 answer
Oracle Column Names of a table
SQL
1 vote143 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
1 vote138 views1 answer
Sql drop with dependencies
SQL
0 vote146 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote143 views1 answer
Create mysql pool connection python flask
SQL