title: How to drop unique in MySQL?
body: <pre><code>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
  </code></pre>
  
  <p>I want to drop the unique key on <code>email</code>,how?</p>