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 votes271 views2 answers
Mysql config user password
SQL
0 vote250 views2 answers
Change database postgres
SQL
0 vote271 views1 answer
Oracle query archivemode
SQL
0 vote287 views1 answer
Alter table add check constraint oracle
SQL
0 vote279 views1 answer
Sqlalchemy empty table
SQL
0 vote272 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
2 votes260 views1 answer
Oracle sql day of month from date
SQL
6 votes276 views2 answers
Postgresql pg_dump
SQL
37 votes262 views3 answers
Duplicate records in sql
SQL
2 votes268 views1 answer
Query any digits record
SQL