OPEN cur1;
REPEAT FETCH cur1 INTO rt,rp,rl,rud,rio,rn;
UPDATE t_usrpayfee tug
IF(rud) THEN
if(rio) THEN
SET tug.uplen=tug.uplen+rl,tug.payfee=rn+tug.payfee
ELSE
SET tug.uplen=tug.uplen+rl,tug.payfee=rn+tug.payfee,tug.intelen=rl+tug.intelen
END IF;
ELSE
if(rio) THEN
SET tug.dwlen=tug.uplen+rl,tug.payfee=rn+tug.payfee
ELSE
SET tug.dwlen=tug.uplen+rl,tug.payfee=rn+tug.payfee,tug.intelen=rl+tug.intelen
END IF;
END IF;
WHERE tug.username=(
select username from t_usrbindip tub
where tub.starttime<=rt and rt<=tub.endtime and tub.ip=rp) AND tug.starttime<=rt and rt<=tug.endtime;
UNTIL done END REPEAT;
CLOSE cur1;提示说
IF(rud) THEN
if(rio) THEN
SET tug.uplen=tug.uplen+rl,
这个地方语法错误,大家帮帮忙!
REPEAT FETCH cur1 INTO rt,rp,rl,rud,rio,rn;
UPDATE t_usrpayfee tug
IF(rud) THEN
if(rio) THEN
SET tug.uplen=tug.uplen+rl,tug.payfee=rn+tug.payfee
ELSE
SET tug.uplen=tug.uplen+rl,tug.payfee=rn+tug.payfee,tug.intelen=rl+tug.intelen
END IF;
ELSE
if(rio) THEN
SET tug.dwlen=tug.uplen+rl,tug.payfee=rn+tug.payfee
ELSE
SET tug.dwlen=tug.uplen+rl,tug.payfee=rn+tug.payfee,tug.intelen=rl+tug.intelen
END IF;
END IF;
WHERE tug.username=(
select username from t_usrbindip tub
where tub.starttime<=rt and rt<=tub.endtime and tub.ip=rp) AND tug.starttime<=rt and rt<=tug.endtime;
UNTIL done END REPEAT;
CLOSE cur1;提示说
IF(rud) THEN
if(rio) THEN
SET tug.uplen=tug.uplen+rl,
这个地方语法错误,大家帮帮忙!
if(rio) THEN
SET tug.uplen=tug.uplen+rl,MYSQL 没有这样的语法。
必须
if xx= '...' then
set ....
end if;