差不多这样 select count(*) from tablename where 1 into @cnt; set @i = 0; while @i < @cnt do set @str = concat('select count(*) from tablename where 1 limit ',i,',1'); prepare s1 from @str; execute s1; drop prepare s1; ... end while;
select count(*) from tablename where 1 into @cnt; set @i = 0; while @i < @cnt do set @str = concat('select count(*) from tablename where 1 limit ',i,',1'); prepare s1 from @str; execute s1; drop prepare s1; set @i = @i + 1; ... end while;
select count(*) from tablename where 1 into @cnt;
set @i = 0;
while @i < @cnt
do
set @str = concat('select count(*) from tablename where 1 limit ',i,',1');
prepare s1 from @str;
execute s1;
drop prepare s1;
...
end while;
set @i = 0;
while @i < @cnt
do
set @str = concat('select count(*) from tablename where 1 limit ',i,',1');
prepare s1 from @str;
execute s1;
drop prepare s1;
set @i = @i + 1;
...
end while;