create procedure p2 (i int(4), v varchar(20), s varchar(20))
begin DECLARE i int(4); DECLARE v varchar(20); DECLARE s varchar(20); select i=userid ,v=sum(money) from tbl_money where userid in (select id as userid from tbl_user) and month(datetime)=month( now( ) ) group by userid; if v>=10000
set s=v*0.15;
else
set s=v;
insert into tbl_totalmoney (userid ,totalmoney ) values(i,s);
end
----------------分隔线-----------------------if v>=10000
set s=v*0.15;
else
set s=v;
这一步总是报错,是不是在mysql里不能这样写,
begin DECLARE i int(4); DECLARE v varchar(20); DECLARE s varchar(20); select i=userid ,v=sum(money) from tbl_money where userid in (select id as userid from tbl_user) and month(datetime)=month( now( ) ) group by userid; if v>=10000
set s=v*0.15;
else
set s=v;
insert into tbl_totalmoney (userid ,totalmoney ) values(i,s);
end
----------------分隔线-----------------------if v>=10000
set s=v*0.15;
else
set s=v;
这一步总是报错,是不是在mysql里不能这样写,
set s=v*0.15;
else
set s=v;
end if
THEN
END IF
这种格式
执行这一步还是报错