Re: Select Statement in Trigger
what's the exact drop command you are using and what version is this?
In older versions of 5.0.x triggers were linked to the table, then later they were attached to the database. It might be it just needs a database qualifier, so....
drop trigger xyz;
becomes
drop trigger db.xyz;
where xyz is the trigger name and db is the database name.
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
Subject
Views
Written By
Posted
5356
October 28, 2005 11:19AM
2487
October 28, 2005 11:47AM
2565
October 28, 2005 11:50AM
2455
October 28, 2005 12:23PM
2637
October 29, 2005 01:57AM
2637
October 29, 2005 03:06AM
2299
October 29, 2005 03:21AM
2195
October 29, 2005 03:28AM
4017
February 28, 2006 01:17AM
2701
February 28, 2006 01:39AM
2465
February 28, 2006 02:54AM
2309
February 28, 2006 07:19AM
2301
February 28, 2006 11:15PM
2283
February 28, 2006 11:45PM
Re: Select Statement in Trigger
2212
February 28, 2006 05:25AM
3427
February 28, 2006 05:46AM
2289
February 28, 2006 06:28AM
2205
March 01, 2006 03:17AM
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.