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

18 votes179 views4 answers
Mysql current date between two dates
SQL
0 vote178 views1 answer
Compare subqueries oracle
SQL
1 vote138 views2 answers
Last working day in week date function in sql
SQL
0 vote143 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
3 votes188 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
3 votes190 views1 answer
Oracle revoke
SQL
13 votes254 views4 answers
Mysql remove foreign key constraint
SQL
0 vote182 views1 answer
Insert overwrite table in mysql in nifi
SQL
6 votes189 views2 answers
Oracle trigger
SQL
1 vote203 views1 answer
Oracle compile schema
SQL