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

3 votes362 views1 answer
Sql select second max
SQL
6 votes277 views2 answers
Clear a table in mysql
SQL
7 votes302 views2 answers
Where keyword sql
SQL
0 vote260 views2 answers
Sqlite
SQL
0 vote311 views1 answer
Mysql delete entire row on condition
SQL
0 vote345 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote289 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote275 views1 answer
Min mysql
SQL
0 vote284 views1 answer
Get id if is not equal in certain table
SQL
2 votes273 views1 answer
Oracle drop table free up space
SQL