Tag Archives: subquery

MySQL subquery 的限制...

官方文件參考 MySQL 5.5 的「Restrictions on Subqueries」這篇。 直接拿官方的範例: SELECT * FROM t1 WHERE s1 IN (SELECT s2 FROM t2 ORDER BY s1 LIMIT 1); 這會出現 subquery 不支援 LIMIT 的錯誤訊息: ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & … Continue reading

Posted in Computer, Database, Murmuring, MySQL, Software | Tagged , , , | 1 Comment