BEGIN
DECLARE startIndex int;
select COUNT(*) INTO RecordCount from test;
SET startIndex = (PageIndex - 1) * PageSize;
SELECT * FROM test ORDER BY id DESC LIMIT startIndex,PageSize ;
END
BEGIN
DECLARE startIndex int;
select COUNT(*) INTO RecordCount from test;
SET startIndex = (PageIndex - 1) * PageSize;
SELECT * FROM test ORDER BY id DESC LIMIT startIndex,PageSize ;
END
转载于:https://www.cnblogs.com/byxxw/p/4892252.html