MY sqlÊý¾Ý¿â²Ù×÷

ÈçºÎÔÚmysqlÀï²éѯǰʮÌõ¼Ç¼
ÎÒÓõÄÊÇ
select top 10 * from Test
µ«Êǽá¹û³ö´í

---

SQL code:
select * from Test limit 0,10

---

select top 10 * from Test

-->

ºÃÏóÊÇʲôlimit
select 10 * from Test where limit 10

°ï¶¥.

---

ÒýÓÃ

SQL code
select * from Test limit 0,10

up

---

select * from Test limit 10 Ò²¿ÉÒÔÕâÑù
mysql> SELECT * from table LIMIT 5,10; // ¼ìË÷¼Ç¼ÐÐ 6-15

//ΪÁ˼ìË÷´Óijһ¸öÆ«ÒÆÁ¿µ½¼Ç¼¼¯µÄ½áÊøËùÓеļǼÐУ¬¿ÉÒÔÖ¸¶¨µÚ¶þ¸ö²ÎÊýΪ -1£º 
mysql> SELECT * from table LIMIT 95,-1; // ¼ìË÷¼Ç¼ÐÐ 96-last.

//Èç¹ûÖ»¸ø¶¨Ò»¸ö²ÎÊý£¬Ëü±íʾ·µ»Ø×î´óµÄ¼Ç¼ÐÐÊýÄ¿£º 
mysql> SELECT * from table LIMIT 5; //¼ìË÷Ç° 5 ¸ö¼Ç¼ÐÐ

//»»¾ä»°Ëµ£¬LIMIT n µÈ¼ÛÓÚ LIMIT 0,n¡£

---

MySQL ÊÇÓÃµÄ limit


select * from Test limit 10;

---

MySQL Óе¥¶ÀµÄ°æ¿é¡£

http://forum.csdn.net/BList/OtherDatabase ÆäËûÊý¾Ý¿â¿ª·¢ 

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

---

µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html

---

select * from tbl_name limit 100;  
  select * from tbl_name limit 100,