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

7 votes254 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
1 vote250 views1 answer
Oracle explain plan
SQL
11 votes244 views2 answers
Sql rank
SQL
3 votes261 views3 answers
Sql last week
SQL
1 vote263 views2 answers
Regex starts with
SQL
0 vote271 views1 answer
Sql drop procedure if exists
SQL
1 vote278 views1 answer
Mysql curdate between two dates
SQL
15 votes261 views7 answers
MYSQL
SQL
0 vote308 views1 answer
What is metadata in sql
SQL
0 vote244 views1 answer
Use between operator in mysql
SQL