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