IF条件语句：begin update huxing if(new.户型=‘平层’)then declare a int(5);set a =select 租平层数量 from huxing;set 租平层数量=a+1;end if;end
mysql触发器里怎么写运算和条件语句
IF条件语句：
begin
update huxing
if(new.户型=‘平层’)
then
declare a int(5);
set a =select 租平层数量 from huxing;
set 租平层数量=a+1;
end if;
end2016-12-12
