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

3 votes332 views1 answer
Delete all content in table mysql
SQL
0 vote383 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
2 votes334 views1 answer
How to add where command in update comand with joins
SQL
0 vote337 views1 answer
Oracle gather table statistics
SQL
1 vote334 views1 answer
Search for tables with name postgresql
SQL
0 vote342 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
2 votes366 views2 answers
Postgres add column integer
SQL
28 votes345 views4 answers
Show tables mysql
SQL
0 vote372 views1 answer
Mod in sql
SQL
0 vote382 views1 answer
Database schema for mcqs type exam in sql
SQL