SHOW CREATE TRIGGER for 5.0 – 5.1.20
CREATE FUNCTION SHOW_CREATE_TRIGGER(in_trigger varchar(255))
RETURNS text READS SQL DATA
BEGIN
DECLARE returnText text;
SELECT CONCAT_WS(
" ",
"CREATE TRIGGER",
TRIGGER_NAME,
ACTION_TIMING,
EVENT_MANIPULATION,
"ON",
EVENT_OBJECT_TABLE,
"FOR EACH ROW",
ACTION_STATEMENT) into returnText
FROM information_schema.triggers;
RETURN returnText;
END
