How to drop unique in MySQL?

mysql indexing sql-drop
Mask picture Mask · Oct 14, 2009 · Viewed 230.7k times · Source 
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?

Answer

Wael Dalloul picture Wael Dalloul · Oct 14, 2009

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

alter table fuinfo drop index email;

Related questions

Does dropping a table in MySQL also drop the indexes?

It's not explicitly mentioned in the documentation (http://dev.mysql.com/doc/refman/6.0/en/drop-table.html). I ask because I just saw a curious database migration in a Rails project where the developer was removing all the indexes before dropping …

Read More
Drop index query is slow

This is the query I'm trying to execute: DROP INDEX id_index on table; I've been able to drop indexes quickly in the past, but this query ran for almost an hour before I gave up on it. What could …

Read More
How do I add indices to MySQL tables?

I've got a very large MySQL table with about 150,000 rows of data. Currently, when I try and run SELECT * FROM table WHERE id = '1'; the code runs fine as the ID field is the primary index. However, for a …

Read More