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 vote192 views1 answer
Postgresql add leading zeros
SQL
1 vote239 views1 answer
Postgresql transaction discard all
SQL
0 vote235 views1 answer
Get enginge db mysql
SQL
0 vote243 views2 answers
Sql trigger difference between for and after
SQL
0 vote230 views1 answer
Sql inserted
SQL
20 votes254 views3 answers
How to open postgresql in mac
SQL
1 vote239 views2 answers
Drop table if exists test
SQL
11 votes235 views3 answers
Change column name sql server management studio
SQL
4 votes237 views2 answers
Convert utc to est sql
SQL
1 vote253 views1 answer
Mysql connect bash
SQL