56,679
社区成员
发帖
与我相关
我的任务
分享mysql触发器里怎么写运算和条件语句
declare sum1,sum2,num int;
select sum(col1),sum(col2) into sum1,sum2 from table1 where sort=NEW.sort;
num = sum1-sum2;
if sum1==sum2 then
update table2 set col3=sum1 where sort=NEW.sort;
end if;
以上语句会报两个地方错误：
num = sum1-sum2和sum1==sum2
请问要怎么写
select sum(col1),sum(col2) into sum1,sum2 from table1 where sort=NEW.sort;
num = sum1-sum2;
if sum1==sum2 then
update table2 set col3=sum1 where sort=NEW.sort;
end if;
以上语句会报两个地方错误：
num = sum1-sum2和sum1==sum2
请问要怎么写
...全文
请发表友善的回复…
发表回复
xuhc2008 2014-01-24
- 打赏
- 举报
赋值用set ，条件判断不用==用=就可以
ermuzi 2014-01-24
- 打赏
- 举报
两处错误：
1.赋值表达式错误：num = sum1-sum2;
正确：SET num = sum1-sum2;
2.条件判别式错误：if sum1==sum2 then
正确：if sum1=sum2 then
Rotel-刘志东 2014-01-23
- 打赏
- 举报
declare sum1,sum2,num int;
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;
ACMAIN_CHM 2014-01-23
- 打赏
- 举报
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;
ssdduy 2014-01-23
- 打赏
- 举报
没人回答这个问题吗
