MySQL Forums
Forum List  »  Triggers

Re: drop trigger if exists?
Posted by: Andrew Gilfrin
Date: August 18, 2005 03:28AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
3226
August 17, 2005 11:57AM
Re: drop trigger if exists?
2604
August 18, 2005 03:28AM
4018
August 18, 2005 11:05AM
2524
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.