Hello Adam,This is the exact syntax to drop the index.DROP INDEX index_name
ON tbl_nameThanksVisolve DB Team .
----- Original Message -----
From: "Adam Lipscombe" <[EMAIL PROTECTED]>
Cc: <mysql@lists.mysql.com>
Sent: Friday, September 01, 2006 3:28 PM
Subject: Drop Index if Exists
Folks,
Does this work in MYSQL 5?
I tried "DROP INDEX [NAME] IF EXISTS;" and got an error "check your
syntax".
Thanks - Adam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]