Re: How do I drop the created Trigger?
look in /var/lib/mysql/databasename
there are files there *.TRG
#cat animal.TRG
TYPE=TRIGGERS
triggers='create trigger animal_bfi before insert on animal for each row set new.name = concat(new.name,\'_\',new.name)'
AHAHH.
drop trigger animal.animal_bfi;
Subject
Views
Written By
Posted
3146
May 06, 2005 11:44PM
2617
May 07, 2005 02:59AM
2541
May 10, 2005 12:21AM
Re: How do I drop the created Trigger?
2142
June 26, 2005 11:12PM
2241
July 22, 2005 03:34PM
2190
July 22, 2005 03:51PM
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.