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
MySql简单分页存储过程
原文：http://www.cnblogs.com/byxxw/p/4892252.html
