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 vote200 views1 answer
Import local sql into remote mysql
SQL
0 vote192 views1 answer
How to save data in database in mysql node
SQL
0 vote212 views1 answer
Azure sql server check foreign key
SQL
2 votes219 views1 answer
Dbms transaction (psql)
SQL
4 votes230 views3 answers
Sql find second highest salary employee
SQL
2 votes193 views2 answers
Postgresql date at timezone
SQL
0 vote226 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote221 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote202 views3 answers
Sql count condition
SQL
1 vote196 views1 answer
Mysql find tables with column name
SQL