如题所述
limitæ¯mysqlçè¯æ³
select * from table limit m,n
å ¶ä¸mæ¯æè®°å½å¼å§çindexï¼ä»0å¼å§ï¼è¡¨ç¤ºç¬¬ä¸æ¡è®°å½
næ¯æä»ç¬¬m+1æ¡å¼å§ï¼ånæ¡ã
select * from tablename limit 2,4
å³ååºç¬¬3æ¡è³ç¬¬6æ¡ï¼4æ¡è®°å½
select * from table limit m,n
å ¶ä¸mæ¯æè®°å½å¼å§çindexï¼ä»0å¼å§ï¼è¡¨ç¤ºç¬¬ä¸æ¡è®°å½
næ¯æä»ç¬¬m+1æ¡å¼å§ï¼ånæ¡ã
select * from tablename limit 2,4
å³ååºç¬¬3æ¡è³ç¬¬6æ¡ï¼4æ¡è®°å½
温馨提示:答案为网友推荐,仅供参考