Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to drop this index in MySQL?

Tags:

indexing

mysql

It's created this way:

create table listings(     id integer unsigned NOT NULL AUTO_INCREMENT,     accountId  integer unsigned default null,     title varchar(300) not null,     country integer unsigned,     region integer unsigned,     type integer unsigned,     price integer,     unit varchar(20) not null,     priceUSD decimal(12,2),     bedrooms integer unsigned,     thumbnail varchar(100) default null,     keywords text,     created datetime,     deleted boolean default 0,     fulltext index (keywords),     PRIMARY KEY (id) ) engine=MyISAM; 

How to drop that fulltext index which has no name?

What if the un-named index is:fulltext index (title ,keywords)?

like image 277
user198729 Avatar asked Dec 31 '09 07:12

user198729


1 Answers

ALTER TABLE listings DROP INDEX keywords; 
like image 109
Haim Evgi Avatar answered Sep 19 '22 10:09

Haim Evgi