56,675
社区成员
发帖
与我相关
我的任务
分享
BEGIN
DECLARE i int DEFAULT 0;
DECLARE f int DEFAULT 0;
DECLARE a int DEFAULT 0;
declare b int DEFAULT 0;
declare c int default 0;
set i=1;
set f=1;
set a=0;
set b=0;
set c=COUNT(orer_frequncy.id);
while i<=c do
select user_id into a from orer_frequncy where user_id=id;-- 用into语句为变量赋值
select user_id_a into b from orer_frequncy where user_id_a=id;
update orer_frequncy
set orer_frequncy.frequncy=1 where orer_frequncy.id=i;
if a=b
then set f=f+1;
else set f=1;
end if;
set i=i+1;
end while;
end