How to drop unique in MySQL

Question

Create Table  CREATE TABLE  fuinfo       fid  int 10  unsigned NOT NULL     name  varchar 40  NOT NULL     email  varchar 128  NOT NULL    UNIQUE KEY  email    email      UNIQUE KEY  fid    fid     ENGINE MyISAM DEFAULT CHARSET utf8   I want to drop the unique key on email how

User · Answer

mysql  DROP INDEX email ON fuinfo   where email is the unique key  rather than the column name   You find the name of the unique key by   mysql gt  SHOW CREATE TABLE fuinfo    here you see the name of the unique key  which could be email 2  for example  So     mysql gt  DROP INDEX email 2 ON fuinfo   mysql gt  DESCRIBE fuinfo    This should show that the index is removed

User · Answer

DROP INDEX column name ON table name  Select the database and query form the sql tab This removes the index of the particular column  It worked for me in PHP MyADMIN

User · Answer

ALTER TABLE  table name  DROP KEY  key name     this will work

User · Answer

ALTER TABLE 0 value addition setup  DROP  INDEX   value code

User · Answer

Try it to remove uique of a column  ALTER TABLE   0 ms labdip details  DROP INDEX column tcx  Run this code in phpmyadmin and remove unique of column

User · Answer

For MySQL 5 7 11  Step-1  First get the Unique Key  Use this query to get it   1 1  SHOW CREATE TABLE User   In the last  it will be like this                 UNIQUE KEY UK 8bv559q1gobqoulqpitq0gvr6  phoneNum                Step-2  Remove the Unique key by this query   ALTER TABLE User DROP INDEX  UK 8bv559q1gobqoulqpitq0gvr6   Step-3  Check the table info  by this query   DESC User   This should show that the index is removed  Thats All

User · Answer

Use below query    ALTER TABLE  table name  DROP INDEX key name    If you don t know the key name then first try below query  you can get key name   SHOW CREATE TABLE table name   OR  SHOW INDEX FROM table name    If you want to remove drop primary key from mysql table  Use below query for that  ALTER TABLE  products  DROP INDEX  PRIMARY     Code Taken from  http   chandreshrana blogspot in 2015 10 how-to-remove-unique-key-from-mysql html

User · Answer

This may help others  alter table fuinfo drop index fuinfo email unique

User · Answer

Simply you can use the following SQL Script to delete the index in MySQL    alter table fuinfo drop index email

User · Answer

There is a better way which don t need you to alter the table   mysql gt  DROP INDEX email ON fuinfo    where email is the name of unique key  index    You can also bring it back like that   mysql gt  CREATE UNIQUE INDEX email ON fuinfo email     where email after IDEX is the name of the index and it s not optional  You can use KEY instead of INDEX   Also it s possible to create  remove  multicolumn unique indecies like that   mysql gt  CREATE UNIQUE INDEX email fid ON fuinfo email  fid   mysql gt  DROP INDEX email fid ON fuinfo    If you didn t specify the name of multicolumn index you can remove it like that   mysql gt  DROP INDEX email ON fuinfo    where email is the column name

[mysql] How to drop unique in MySQL?

Examples related to mysql

Examples related to indexing

Examples related to sql-drop