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

14 votes236 views2 answers
Oracle add attribute to table
SQL
0 vote236 views2 answers
SQL Server Standard
SQL
0 vote238 views2 answers
Sql update multiple tables
SQL
-2 votes205 views1 answer
Use of where in left join in mysql
SQL
6 votes223 views2 answers
Join vs union
SQL
0 vote248 views1 answer
Display all node label neo4j
SQL
25 votes240 views4 answers
Import mysql dump command line
SQL
-1 vote233 views4 answers
Restart mysql server ubuntu
SQL
4 votes197 views1 answer
Sql delete where in select
SQL
1 vote219 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL