How to drop unique in MySQL?

indexing, mysql, sql-drop

Solution

Simply you can use the following SQL Script to delete the index in MySQL:

alter table fuinfo drop index email;

Problem

``` 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?

Original source