mysql 的limit 問題

hmlymt

我就想知道  

  limit的第二個參數(shù) 到底可不可以為 -1


  limit 10，-1 是不是能查出從10到最后一條

  網(wǎng)上的帖子都說可以， 但是在客戶端測試確實不行


  高手請給出確切答案  

fanglq04

不行  報錯

mysql> select * from uc_pms limit 10,-1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 1

小版主殺手

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1' at line 3
SELECT *
FROM `movie_busi_cart`
LIMIT 10 , -1

確實不能 如果要用到最后幾條記錄 可以加個order by  主鍵嘛 desc limit n

justin033

你這是不看文檔的結果

http://dev.mysql.com/doc/refman/5.5/en/select.html


The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments, which must both be nonnegative integer constants, with these exceptions:

    Within prepared statements, LIMIT parameters can be specified using ? placeholder markers.

    Within stored programs, LIMIT parameters can be specified using integer-valued routine parameters or local variables as of MySQL 5.5.6.