create PROCEDURE USP_GetByPager( _pageindex int, _pagesize int ) BEGIN declare _currentpageindex int DEFAULT (_pageindex-1)*_pagesize; select * from A a inner join ( select id from A order by id limit _currentpageindex,_pagesize) b on a.id=b.id ; end
原文：http://www.cnblogs.com/gaobing/p/4421283.html