MySQLÏÂlimitºÍjoinµÄÓÅ»¯½¨Òé

PHPÖзÖÒ³¿Ï¶¨»áʹÓõ½MySQLµÄlimit,´ó²¿·Ö¶ÔÀàËÆ"select * from title where uid =** order by id desc limit m,n"ºÜÊìϤ,Ò²²»ÊÇÈ«²¿¶¼ÄÜ¿´³öÀïÃæÓÐʲô²»¶Ô,¿ÉÊǵ±ÊÇÔÚ´óÊý¾ÝÁ¿Ï²Ù×÷ÄØ,±ÈÈç°ÙÍòÀàËÆ"select * from title where uid =177 order by id desc limit 1234567,20"¾Í»á·¢ÏÖsqlÖ´ÐеÄʱ¼äÃ÷ÏÔ±äµÃºÜ³¤,ΪʲôÄØ? ÏÈ´ÓMySQLµÄlimitÔ­Àí˵Æð,ʹÓÃlimit m,nÊÇʱºò,MySQLÏÈɨÃè(m+n)Ìõ¼Ç¼,È»ºó´ÓmÐпªÊ¼È¡nÐÐ.±ÈÈçÉÏÃæµÄÀý×Ó¾ÍÊÇÏÈɨÃè1234587ÌõÊý¾Ý,ÕâÑùµÄ»°sqlÄÜ¿ìÂð?Õâ¾ÍÒªÇóÎÒÃǾ¡¿ÉÄܵļõÉÙmµÄÖµ,ÉõÖÁûÓÐmÖ±½Ólimit nÕâÑùÊÇsql. ¿´¸öÀý×Ó: mysql> select id,substr(mobile from 1 for 7),time,cpid,linkid from cp_mo100227 where cpid=769 limit 888888,10;
+----------+-----------------------------+---------------------+------+----------------------+
| id       | substr(mobile from 1 for 7) | time                | cpid | linkid               |
+----------+-----------------------------+---------------------+------+----------------------+
| 11535090 | 1353554                     | 2010-02-24 21:07:48 |  769 | 21064905903309587933 |
| 11535091 | 1353750                     | 2010-02-24 21:07:48 |  769 | 21064912943389480033 |
| 11535093 | 1353394                     | 2010-02-24 21:07:48 |  769 | 21064912945389480075 |
| 11535098 | 1343073                     | 2010-02-24 21:07:50 |  769 | 21064905865309587977 |
| 11535100 | 1369270