declare sum1,sum2,num int;
select sum(col1),sum(col2) into sum1,sum2 from table1 where sort=NEW.sort;
set num = sum1-sum2;
if sum1=sum2 then
update table2 set col3=sum1 where sort=NEW.sort;
end if;
select sum(col1),sum(col2) into sum1,sum2 from table1 where sort=NEW.sort;
set num = sum1-sum2;
if sum1=sum2 then
update table2 set col3=sum1 where sort=NEW.sort;
end if;
select count(col1),sum(col2) into sum1,sum2 from table1 where sort=new.sort;
set num=sum1-sum2;
if num1=num2 then
update table2 set col3=sum1 where sort=new.sort;
end if;
1.赋值表达式错误:num = sum1-sum2;
正确:SET num = sum1-sum2;2.条件判别式错误:if sum1==sum2 then
正确:if sum1=sum2 then