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 vote197 views1 answer
Why mysql is used?
SQL
1 vote194 views1 answer
Oracle update with sequence
SQL
5 votes153 views1 answer
Copy table from one database to another mysql
SQL
0 vote185 views1 answer
Remove default constraint sql server
SQL
0 vote208 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
1 vote207 views3 answers
Update from select sqlite
SQL
6 votes193 views2 answers
Mysql get yesterday
SQL
2 votes194 views1 answer
Cast string to datetime mysql
SQL
0 vote255 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote205 views1 answer
Mariadb maximum left join
SQL