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 vote188 views1 answer
PostgreSQL types and C# types
SQL
0 vote215 views1 answer
How to check oracle index table
SQL
0 vote205 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote270 views1 answer
Insert into table with only identity column
SQL
1 vote208 views1 answer
Create new table from old table
SQL
5 votes185 views1 answer
Postgresql functions
SQL
1 vote183 views1 answer
Sql avg group by
SQL
13 votes184 views2 answers
Check if value is null mysql
SQL
0 vote197 views1 answer
Join in update query in mysql
SQL
0 vote247 views1 answer
Sqlite trim
SQL