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 vote114 views1 answer
MySQL AND Operator
SQL
0 vote139 views1 answer
Where field is null sql knex
SQL
2 votes127 views1 answer
Drop sequence
SQL
0 vote120 views1 answer
Incorrect string value: mysql
SQL
-1 vote111 views1 answer
Sql getdate date only
SQL
-1 vote124 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote139 views1 answer
How to get data from 2 database
SQL
40 votes188 views4 answers
PostgreSQL add column
SQL
0 vote97 views2 answers
Influxdb delete measurement based on date
SQL
3 votes112 views2 answers
Oracle grants
SQL