How to drop unique in MySQL?

user_179364 0
Viewed 239140
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?

sql-drop indexing mysql
10 Answers

ALTER TABLE 0_value_addition_setup  DROP  INDEX   value_code
user_50154270
Related