CREATE TABLE trigger_test_table_1 ( id INT(10) ); CREATE TABLE trigger_test_table_2 LIKE trigger_test_table_1; CREATE TRIGGER monkeyone AFTER INSERT ON trigger_test_table_1 FOR EACH ROW BEGIN END; CREATE TRIGGER monkeytwo AFTER INSERT ON trigger_test_table_2 FOR EACH ROW BEGIN END; SHOW TRIGGERS \G SHOW TRIGGERS LIKE 'monkey%'\G SHOW TRIGGERS LIKE 'monkeyone'\G SHOW TRIGGERS LIKE 'monkeytwo'\G SHOW TRIGGERS LIKE '%two'\G SHOW TRIGGERS \G DROP TABLE trigger_test_table_1; DROP TABLE trigger_test_table_2;