Çó¸ßÊÖÐÞ¸ÄÒ»MYSQLÓï¾ä

ÏÖÓÐMYSQLÓï¾ä
SQL code:
select t.id,a.uid,a.uname,t.ucomment,t.utime
from a left join b t using(uid)
where 2>(select count(*) from b where uid=t.uid and utime<t.utime)
and a.uid<=6



²»¹ý´Ë´¦µÄa.uid <6°ÑuidµÄÖµ¹Ì¶¨×¡ÁË£¬
ÈçºÎÐÞ¸Äһϣ¬ÀûÓÃuidµÄÖµ½øÐзÖÒ³²éѯÄØ

---

Ö»ÓÐÓÃSP£¬½«²ÎÊý´«µÝ½øÈ¥
ÀàËÆ
select t.id,a.uid,a.uname,t.ucomment,t.utime
from a left join b t using(uid)
where 2>(select count(*) from b where uid=t.uid and utime <t.utime)
and a.uid <=cuid

call sp(6)

---

select t.id,a.uid,a.uname,t.ucomment,t.utime
from a left join b t using(uid)
where 2>(select count(*) from b where uid=t.uid and utime <t.utime)
limit 20,10

limit 20,10 ÏÔʾµÚ21Ìõ¼Ç¼µ½µÚ30¹²10Ìõ¼Ç¼¡£Äã¿ÉÒÔÓÃÕâ¸öÀ´·ÖÒ³¡£

---

ÒýÓÃ

select t.id,a.uid,a.uname,t.ucomment,t.utime
from a left join b t using(uid)
where 2>(select count(*) from b where uid=t.uid and utime <t.utime)
limit 20,10

limit 20,10 ÏÔʾµÚ21Ìõ¼Ç¼µ½µÚ30¹²10Ìõ¼Ç¼¡£Äã¿ÉÒÔÓÃÕâ¸öÀ´·ÖÒ³¡£

ÿҳҪ²é³ö10¸öuidÏà¶ÔÓ¦µÄÐÅÏ¢£¬ËùÒÔ˵ÕâÑùÊDz»ÐеÄ

http://topic.csdn.net/u/20100108/15/62c5af0c-3ba4-4816-8117-02b489db57cd.html
½¨SQLÓï¾äÔÚÕâ¸öÁ´½ÓÀïÃæ

---