高质量触发器欣赏

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//