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
本文共 238 字，大约阅读时间需要 1 分钟。
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