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 votes160 views1 answer
Create column sql server
SQL
0 vote123 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote128 views1 answer
Create schema sql server
SQL
0 vote143 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote136 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote138 views1 answer
What is between keyword used for
SQL
-1 vote85 views2 answers
On delete set default sql server
SQL
0 vote138 views1 answer
Mysql date only no time
SQL
0 vote154 views1 answer
Python sqlalchemy connection show server
SQL
104 votes330 views2 answers
Like in mysql
SQL