Question

请求帮助MySQL Query:SELECT * FROM destoon_article_23 WHERE status=3 ORDER BY LIMIT 0,20

MySQL Query:SELECT * FROM destoon_article_23 WHERE status=3 ORDER BY LIMIT 0,20
MySQL Error: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 'LIMIT 0,20' at line 1 MySQL Errno:1064
Message:MySQL Query Error

Answer 1

缺少排序字段：
SELECT *
FROM destoon_article_23
WHERE status=3
ORDER BY "排序字段" [ASC|DESC]
LIMIT 0,20

Answer 2

order by 缺少字段吧，你要排序需指定排序的列

Answer 3

SELECT * FROM destoon_article_23 WHERE status=3 ORDER BY LIMIT 0,20

--------ORDER BY 后跟的列呢？
加上 应该没问题

Answer 4

ORDER BY 后 过 应 该 有 排 序 字 段

Answer 5

SELECT * FROM destoon_article_23 WHERE status=3 ORDER BY LIMIT 20