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

2 votes105 views1 answer
Sql alchemy or
SQL
0 vote109 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote105 views1 answer
Postgres populate table from another table
SQL
0 vote122 views1 answer
Sql get table last modified time
SQL
0 vote122 views1 answer
Create database like
SQL
0 vote115 views1 answer
Download sql file of countries names
SQL
7 votes236 views2 answers
Drop index oracle
SQL
4 votes120 views3 answers
Rename table column postgresql
SQL
1 vote147 views1 answer
Mysql tables max count
SQL
0 vote121 views1 answer
Sql server pivot rows to columns
SQL