PREPARE s1 FROM 'SELECT * FROM ysxx LIMIT ?,?';
set @_limit=1;
set @_limit1=(select count(1) from ysxx);
EXECUTE s1 USING @_limit,@_limit1;
PREPARE s1 FROM 'SELECT * FROM ysxx LIMIT ?,?';
set @_limit=1;
set @_limit1=(select count(1) from ysxx);
EXECUTE s1 USING @_limit,@_limit1;