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

12 votes96 views4 answers
Mysql get date difference in hours
SQL
10 votes51 views1 answer
Oracle view dependencies
SQL
0 vote95 views1 answer
Check if a word appears at the end sql query
SQL
4 votes99 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote107 views1 answer
Redudancy in SQL
SQL
51 votes308 views6 answers
Installing mysql on ubuntu
SQL
0 vote94 views1 answer
Sql min
SQL
1 vote104 views1 answer
Load sql into mamp
SQL
36 votes106 views6 answers
Rename table sql
SQL
0 vote90 views1 answer
Faire une recherche par liste de mot clé sql
SQL