And the answer to this is, YES, the whole ALTER query FAILS and NONE of the
indicies are dropped. *sigh*
mysql> ALTER TABLE poop DROP INDEX name_2, DROP INDEX name_3, DROP INDEX
name_4;
ERROR 1091: Can't DROP 'name_4'. Check that column/key exists
> -----Original Message-----
> From: Daevid Vincent [mailto:daevid@stripped]
>
> What happens if I list out all the indexes that there _could_
> be in one ALTER line like that, and one of the indexes doesn't
> actually exist? Will the whole ALTER fail?

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.