On Dec 5, 2007 7:03 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote:
> Sorry I got carried away in my former response.
>
> When I tried this,
> ALTER IGNORE TABLE tbl_name DROP INDEX seems to fail if the index does not
> exist.
Right. ALTER IGNORE means that rows that violate unique indexes won't
b
Sorry I got carried away in my former response.
When I tried this,
ALTER IGNORE TABLE tbl_name DROP INDEX seems to fail if the index does not
exist.
The DROP INDEX statement is part of a larger script, what I want is for the script to conue to
execute if this index does not exist.
e.g.
ALTE
Fantastic, thanks very much!
Adam
Rob Wultsch wrote:
On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote:
Folks
How can one conditionally drop an index in MySQL?
Googling shows that the "drop index" does not support an "if exists" qualifier
- apparently a bug
has been raised
ame,'`
> DROP INDEX `',ndxName,'`');
> SET @SQLStmt = SQLStatement;
> PREPARE s FROM @SQLStmt;
> EXECUTE s;
> DEALLOCATE PREPARE s;
> END IF;
>
> END $$
>
> DELIMITER ;
>
> Give it a try !!!
>
>
> -
SET @SQLStmt = SQLStatement;
PREPARE s FROM @SQLStmt;
EXECUTE s;
DEALLOCATE PREPARE s;
END IF;
END $$
DELIMITER ;
Give it a try !!!
-Original Message-
From: Rob Wultsch [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 12:51 PM
To: Adam Lipsco
On Nov 29, 2007 4:34 AM, Adam Lipscombe <[EMAIL PROTECTED]> wrote:
> Folks
>
>
> How can one conditionally drop an index in MySQL?
>
> Googling shows that the "drop index" does not support an "if exists"
> qualifier - apparently a bug
> has been raised but as far as I know its not fixed yet.
>
> D
