How to drop this index in MySQL?

ALTER TABLE {your_table_name} DROP INDEX {your_index_name}

DROP INDEX {your_index_name} ON {your_tbl_name}

ALTER TABLE listings DROP INDEX keywords;

Run this command in the mysql client:

mysql> SHOW CREATE TABLE listings;

It will show you the DDL for the table, including the system-assigned name for the index.

Related