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

2 votes393 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
2 votes329 views1 answer
Oracle create directory
SQL
0 vote330 views1 answer
Query archive mode
SQL
2 votes352 views2 answers
Get all tables using like
SQL
0 vote340 views1 answer
Reona
SQL
8 votes340 views2 answers
Select table column name in sql
SQL
0 vote329 views1 answer
Utiliser sql ligne de commande
SQL
0 vote334 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote328 views1 answer
Postgresql select fast check no rows
SQL
0 vote426 views1 answer
Run docker container with database as rds metabase
SQL