Mysql set 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 */

Mysql drop key

ALTER TABLE tbl_quiz_attempt_master
  DROP INDEX `PRIMARY`;

Source: stackoverflow.com

Similar codes

1 vote127 views1 answer
Rails run native ssql query
SQL
11 votes126 views3 answers
Change column name sql server management studio
SQL
24 votes126 views5 answers
Sql server insert into select
SQL
0 vote125 views2 answers
Sql query inner join 3 tables
SQL
0 vote156 views1 answer
Gcloud sql instance list
SQL
10 votes124 views1 answer
Oracle view dependencies
SQL
2 votes172 views3 answers
Mysql cheat sheet
SQL
3 votes127 views1 answer
Oracle transaction commit rollback example
SQL
5 votes124 views1 answer
Ignore duplicate rows in sqlite
SQL
1 vote128 views1 answer
Postgresql create table with timestamp
SQL