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 vote299 views1 answer
Print boolean in plsql
SQL
4 votes268 views2 answers
How to delete row in sql
SQL
0 vote279 views1 answer
View acl table oracle
SQL
12 votes264 views4 answers
SQL Where
SQL
2 votes303 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote281 views1 answer
Excute raw query
SQL
3 votes293 views2 answers
Postgres alter table owner
SQL
0 vote364 views1 answer
TSQL Find csv file in folder
SQL
2 votes269 views3 answers
Application.properties spring boot mysql
SQL
0 vote266 views1 answer
Sql right characters
SQL