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 vote133 views1 answer
Show tables in cassandra cql
SQL
0 vote127 views1 answer
Mysql timediff
SQL
0 vote177 views1 answer
Regex mongoose
SQL
0 vote142 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
10 votes144 views4 answers
Join multiple tables in sql
SQL
0 vote103 views1 answer
Oracle sysdba connect as another user
SQL
0 vote117 views1 answer
Mysql last 6 months
SQL
7 votes132 views3 answers
Select latest entry in sql table
SQL
0 vote150 views1 answer
Sql last time database was accessed
SQL
0 vote187 views1 answer
Setting default value for Boolean data type in SQL
SQL