MySQL触发器学习总结: 代码如下: #创建触发器,当往order表中添加记录是，更新goods表 delimiter $ CREATE TRIGGER trigger1 AFTER INSERT ON `order` FOR EACH ROW BEGIN UPDATE goods SET num=num-new.much WHERE id=new.gid;