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 vote360 views1 answer
Codeigniter 3 get best-selling products
SQL
1 vote366 views1 answer
Altering the column name in MySQL to have a default value
SQL
-1 vote342 views2 answers
On delete set default sql server
SQL
0 vote404 views1 answer
Add new column in sql with foreign key
SQL
0 vote372 views1 answer
Sql server create constraint
SQL
0 vote346 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote304 views1 answer
Sql count how many times a value appears
SQL
0 vote359 views1 answer
C# datetime to sql server datetime
SQL
0 vote364 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote375 views1 answer
Sql mod even odd
SQL