>I made a mistake of not giving a name to an index.
>alter table sometable add index ( field1, field2 )
>I would like to remove this index but I can't figure it out.
If you perform SHOW INDEX FROM tablename; what do you get as the key_name? Try
dropping it based on what you see.
--
MySQL Gene
hi everyone,
I made a mistake of not giving a name to an index.
alter table sometable add index ( field1, field2 )
I would like to remove this index but I can't figure it out.
I tried:
alter table sometable drop index (field1,field2)
How do I fix this?
Thank you.
-gohaku
--
MySQL General Mailing L