復(fù)制代碼 代碼如下:

#創(chuàng)建觸發(fā)器,當(dāng)往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;
END$

復(fù)制代碼 代碼如下:

#創(chuàng)建觸發(fā)器
#觸發(fā)時(shí)間：before
delimiter $
CREATE TRIGGER trigger1
BEFORE INSERT ON `order`
FOR EACH ROW
BEGIN
IF new.much >5 THEN
SET new.much=5
END IF;
UPDATE goods SET num=num-new.much WHERE id=new.gid;
END$