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

-1 vote186 views1 answer
How to check table exists or not in postgresql
SQL
6 votes200 views2 answers
Mysql execute file
SQL
0 vote192 views1 answer
Heidisql check how much space a row
SQL
0 vote211 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote208 views3 answers
Duplicate row mysql
SQL
0 vote189 views1 answer
Sqlcmd no headers
SQL
24 votes191 views4 answers
How to add column sql
SQL
0 vote189 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote262 views1 answer
Difference between where and having clause
SQL
3 votes201 views2 answers
How to modify rows in SQL Server
SQL