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

0 vote371 views1 answer
The fetch keyword oracle
SQL
1 vote322 views1 answer
Select random sample sql
SQL
0 vote361 views1 answer
Mysql min value row
SQL
0 vote376 views1 answer
How to make case insensitive in sql
SQL
0 vote341 views1 answer
How to avoid duplicate records in sqlite
SQL
1 vote399 views2 answers
This month mysql where
SQL
0 vote398 views1 answer
Traccar mysql
SQL
10 votes330 views2 answers
Django mysql
SQL
0 vote362 views1 answer
Mysql check if lowercase
SQL
0 vote373 views1 answer
How to delete duplicate rows in oracle
SQL