我想知道我的程序到底出现了什么问题,请各位大神帮忙看一下
存储过程的目的是将表orer_frequncy的frequnsy更新成user_id的频次
[Err] 1111 - Utilisation invalide de la clause GROUPBEGIN
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
存储过程的目的是将表orer_frequncy的frequnsy更新成user_id的频次
[Err] 1111 - Utilisation invalide de la clause GROUPBEGIN
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
除了第一行的begin没有错误,其他都是错的。语法写正确了再来问吧