create procedure killRepeat() begin declare i int; set @x="'a','b','c','b'"; set i=0; set length=x.LENGTH-8;--求其长度 declare temp varchar; temp='a'; while i<length do if temp <> x.substring[i] then temp=temp.contact(temp,x.substring[i]) end; set i=i+1; end while; end;//我未调试,会报错,我们再一同修改。
begin
declare i int;
set @x="'a','b','c','b'";
set i=0;
set length=x.LENGTH-8;--求其长度
declare temp varchar;
temp='a';
while i<length do
if temp <> x.substring[i] then
temp=temp.contact(temp,x.substring[i])
end;
set i=i+1;
end while;
end;//我未调试,会报错,我们再一同修改。