create trigger orderClose
after insert on receive
for each row
begin
set @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 then
    update order_info set valid="1" where num=new.number;
end if;
end//

drop trigger orderClose//