Re: drop trigger if exists?
There is no mention of it in the documentation, I know this wasn't available in the older versions due to the lack of SHOW and INFORMATION_SCHEMA details available.
Can you get drop trigger to work without the if exists?
There was a swtich from triggers being associated with tables directly to them being associated to the database. Therefore the old drop syntax needed a table prefix where the new can have a database prefix (this is not required if you are using the database it's attached to).
I'm running 5.0.7 here so I can't check right now.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information
Edited 1 time(s). Last edit at 08/18/2005 03:31AM by Andrew Gilfrin.
Subject
Views
Written By
Posted
3363
August 17, 2005 11:57AM
Re: drop trigger if exists?
2688
August 18, 2005 03:28AM
4098
August 18, 2005 11:05AM
2591
August 19, 2005 05:54AM
Sorry, you can't reply to this topic. It has been closed.
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.