°ÙÍòÊý¾Ý·ÖÒ³SQLÓï¾äʵÀý(MySQL)

È¡×ÜÊý:
Select SQL_BUFFER_RESULT count(col1) as all_ID from foods;
¿ªÊ¼: start = 0
ÿҳ³¤¶È: page_length = 16
×ÜÒ³Êý: pages = all_ID/page_length
×îºóÒ»Ò³µÄ¼Ç¼Êý: odd = all_ID%page_length

²éѯµ±Ç°Ò³:
set @rownum=0;
select SQL_BUFFER_RESULT id,title,url,img,price
from foods,
    ( select my_id from
        ( select id as my_id,(@rownum:=@rownum+1) as row_id from foods
        order by modified desc
        ) as tmp
        where row_id between '@{int:1+start}'
            and '@{int:start+page_length}'
    ) as temp
where my_id=id

ʵ¼ÊЧ¹û:
http://www.dfwgw.com/dGFva2UvbGlzdF9hbGwuaHRtbA==url.html

±í½á¹¹²Î¿¼:
CREATE TABLE `foods` (                                   
          `id` int(11) NOT NULL AUTO_INCREMENT,               
          `title` varchar(100) NOT NULL,                         
          `url` varchar(100) NOT NULL,