What query to remove index on fields?

[StevenHu]

I accidentally create a second index on several fields, not realizing that I already had such an index. PHPMyAdmin showed me my error. What is the query that removes an index?

Thanks!

[tripy]

http://dev.mysql.com/doc/refman/5.1/en/drop-index.html

[StevenHu]

Thank you very much!

[StevenHu]

I used PHPMyAdmin to create the index. I checked each column for which I wanted included in the index, then clicked on the Index button. I notice that to drop an index, one specifies the name of the index:

DROP INDEX index_name ON tbl_name

I did not give a name to any of my indexes (PHPMyAdmin did not prompt for one). How do I drop an unnamed index? Using * in place of the name did not work.

Thanks.

[r937]

run the following query in the SQL tab:

SHOW CREATE TABLE tablename

this should show you the index name

[StevenHu]

Great! That solved my problem. Another scrap of code to add to my cheat sheet!

Thanks,
Steve