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 votes171 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
16 votes172 views4 answers
Mysql import from sql file
SQL
0 vote165 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote168 views1 answer
Sum value by month sql
SQL
2 votes212 views2 answers
Mysql search for column name in all tables
SQL
10 votes191 views4 answers
Inner join in update query mysql
SQL
2 votes247 views1 answer
How to select from mssql
SQL
0 vote161 views1 answer
How to order result of subquery in select
SQL
0 vote168 views2 answers
Database owner can't create new tables postgres
SQL
0 vote158 views1 answer
Oracle list of long running queries
SQL