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 vote329 views3 answers
Nth highest salary
SQL
0 vote309 views1 answer
How to create an SQL save method in ruby
SQL
0 vote355 views1 answer
Python sqlalchemy connection show server
SQL
0 vote315 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
2 votes319 views1 answer
Sql update from different table
SQL
0 vote321 views1 answer
Sql server alter table column nullable
SQL
0 vote321 views1 answer
Test database for sql
SQL
2 votes322 views1 answer
Sqlite3 show columns name
SQL
0 vote294 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote310 views1 answer
How to set all the min and sec data to zero in sql server
SQL