查看所有触发器
show triggers;
删除触发器
DROP TRIGGER IF EXISTS table1_trigger;
创建触发器(举例 当table1的INSERT发生时触发)
CREATE TRIGGER `table1_trigger` AFTER INSERT ON `table1` FOR EACH ROW BEGIN INSERT INTO table2 VALUES ( new.ID, new.STATUS, new.TIME, ); END;
show triggers;
DROP TRIGGER IF EXISTS table1_trigger;
CREATE TRIGGER `table1_trigger` AFTER INSERT ON `table1` FOR EACH ROW BEGIN INSERT INTO table2 VALUES ( new.ID, new.STATUS, new.TIME, ); END;