drop procedure if exists sp1;
delimiter $$
create procedure sp1($no int,$size int)
begin
declare $n int;
set $n=($no-1)*$size;
select *from table_1 limit $n,$size;
end if;
end $$
delimiter ;
call sp1(5,5);
若是select *from table_1 limit $size*($no-1),$size;
便不行