高质量触发器欣赏
create trigger orderCloseafter insert on receivefor each rowbeginset @sum=(select sum(qty) from receive where number=new.number group by number);set @sumOrder=(select qty from order_info where num=new.number group by num);if @sum=@sumOrder thenupdate order_info set valid="1" where num=new.number;end if;end//drop trigger orderClose//在做那个入库时，把订单的关闭程序时。
