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 vote141 views2 answers
Identity syntax in sql
SQL
8 votes145 views2 answers
Safe update mode in mysql
SQL
1 vote137 views1 answer
Sql server datetime vs datetime2
SQL
2 votes140 views1 answer
Check isolation level in mysql
SQL
0 vote130 views1 answer
Excute raw query
SQL
0 vote183 views1 answer
Oracle plsql sleep
SQL
0 vote130 views1 answer
Add plugins to mysql workbench
SQL
8 votes127 views2 answers
Phpmyadmin password
SQL
0 vote149 views1 answer
Shell script to log mysql cpu usage
SQL
16 votes146 views3 answers
Update table from another table
SQL