>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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]