DELIMITER $$
CREATE TRIGGER trigger_name
[ BEFORE|AFTER ]  [ INSERT|UPDATE|DELETE ]
ON table_name FOR EACH ROW
BEGIN
      -- trigger statements
END
$$

-- trigger time
[ BEFORE|AFTER ] 

-- trigger event
[ INSERT|UPDATE|DELETE ]

-- To show source of trigger
SHOW CREATE TRIGGER trigger_name;


-- Show all existing triggers
SHOW TRIGGERS;

SHOW TRIGGERS FROM db-name;
or
SHOW TRIGGERS IN db-name;

SHOW TRIGGERS FROM db-name LIKE '%table-name%'
or
SHOW TRIGGERS FROM db-name WHERE `table` = "table-name"

DROP TRIGGER trigger_name;
DROP TRIGGER IF EXISTS trigger_name;