Re: Show Triggers ?

[Paul McArdle]

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;