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

0 vote109 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote137 views1 answer
Set classpath for mysql-connector.jar
SQL
-1 vote103 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote152 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
10 votes57 views2 answers
Django mysql
SQL
12 votes112 views1 answer
Docker run mysql image
SQL
0 vote100 views1 answer
Sql delete where x or y or z
SQL
0 vote114 views2 answers
Sql regex vowel
SQL
0 vote108 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote105 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL