mysqlÖвéѯµÚ¼¸Ìõµ½µÚ¼¸Ìõ¼Ç¼µÄ·½·¨
±ÈÈçÏóSQLSERVERÖеÄTOP¹Ø¼ü×Ö ORACLEÖеÄαÁÐ ÔÚMYSQLÖÐÓÃʲô·½·¨ÊµÏÖ£¿£¿£¿
SQL code: select * from tb limit 1,10; select * from table1 order by id limit 20,10; È¡³ö°´£É£ÄÅÅÐòµÄµÚ11ÌõÖÁ20Ìõ¼Ç¼£¬Ò»¹²10ÌõÒýÓà SQL codeselect*from tb limit1,10; лл£¬½Ó´¥MYSQL²»¾Ã£¬Õâ¸ö¹Ø¼ü×Öȷʵ²»´í£¬ÓÃÆðÀ´Ò²Âù·½±ãÒýÓà select * from table1 order by id limit 20,10; È¡³ö°´£É£ÄÅÅÐòµÄµÚ11ÌõÖÁ20Ìõ¼Ç¼£¬Ò»¹²10Ìõ ÊÇ21ÖÁ30µÄ°É
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡ лл¸÷λÁË ¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î ±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡ ллÁË ¼Æ»®ÈÎÎñ...php....sql...truncate....OK Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
PHPCMSÆóÒµ»ÆÒ³2008·ÖÒ³ÎÊÌâ ÎÒÓÃÒÔÏ·½Ê½Ç󯽾ùÊý {get sql="SELECT DISTINCT c.*, (select round(avg(sort1)) from `phpcms_yp_dp` where userid=c.userid) avgsort1, (select round(avg(avgp ......
ÔÌûÇë¿´ http://topic.csdn.net/u/20100115/09/98c6ac75-d6fe-4b6c-90dc-336a738a0c0f.html?14601 ×ܽáϾÍÊÇ apache php mysql ÎÒÈ«²¿¶¼ÓõÄÊÇgb2312£¬ÓÐʲô°ì·¨¿ÉÒÔ²»ÓÃÿ´Îmysql_query('SET character_set_r ......