delimiter // create procedure listpage (IN num1 int,IN num2 int) begin set @sql = concat('select * from stuinfo limit ',num1,',',num2); //连接的sql语句 prepare sq from @sql; execute sq; deallocate prepare sq; end //