我有MySQL Server版本5.1.53.我在找一個小時自己回答這個問題.包括閱讀文檔本身http://dev.mysql.com/doc/refman/5.1/en/select.html
目前,我運作此查詢.
SELECT dv2.timestamp
FROM data_val AS dv2
WHERE dv2.timestamp > '2011-06-10 22:26:25' ORDER BY dv3.timestamp DESC
LIMIT 1
然後,我試圖通過确定MAX_QUERIES減1的計算來消除ORDER BY文法.
SELECT (COUNT(*)-1) total
FROM data_val AS dv2a
WHERE dv2a.timestamp > '2011-06-10 22:26:13'
最終查詢變為
SELECT dv2.timestamp
FROM data_val AS dv2
WHERE dv2.timestamp > '2011-06-10 22:26:13'
LIMIT (
SELECT (COUNT(*)-1) total
FROM data_val AS dv2a
WHERE dv2a.timestamp > '2011-06-10 22:26:13'
), 1
錯誤是：
#1064-您的SQL文法有誤；檢查與您的MySQL伺服器版本對應的手冊以擷取正确的文法,以在第4行的'(SELECT(COUNT(*)-1)total FROM data_val AS dv2a’附近使用
我還嘗試将子查詢放在OFFSET文法之後.但仍然錯誤.
您是否知道為什麼我的子查詢不起作用？
I need technical details with short,
simple, and clean explanation.