Cacher is the code snippet organizer for pro developers

CREATE TRIGGER name_of_trigger
AFTER INSERT ON the_table_name 
FOR EACH ROW
INSERT INTO the_other_table_name 
(the_column, another_column) 
VALUES 
(1234, NOW());

DELIMITER $$
CREATE TRIGGER name_of_trigger
AFTER INSERT ON the_table_name 
FOR EACH ROW
BEGIN
  INSERT INTO the_other_table_name 
  (the_column, another_column) 
  VALUES 
  (1234, NOW());
  
  INSERT INTO the_other_maybe_audit_table 
  (the_column, another_column) 
  VALUES 
  (1234, NOW());
END$$
DELIMITER ;