Re: Display triggers that already exist...

[Peter Brawley]

CREATE PROCEDURE ShowCreateTrigger( IN db CHAR(64), IN tbl CHAR(64) )
BEGIN
SELECT
CONCAT(
'CREATE TRIGGER ',trigger_name, CHAR(10),
action_timing,' ', event_manipulation, CHAR(10),
'ON ',event_object_schema,'.',event_object_table, CHAR(10),
'FOR EACH ROW',CHAR(10),
action_statement,CHAR(10)
) AS 'Triggers'
FROM information_schema.triggers
WHERE event_object_schema = db AND event_object_table = tbl;
END;