请求帮助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
第1个回答 推荐于2018-04-21
缺少排序字段：
SELECT *
FROM destoon_article_23
WHERE status=3
ORDER BY "排序字段" [ASC|DESC]
LIMIT 0,20本回答被网友采纳
SELECT *
FROM destoon_article_23
WHERE status=3
ORDER BY "排序字段" [ASC|DESC]
LIMIT 0,20本回答被网友采纳
第2个回答 2011-07-27
order by 缺少字段吧，你要排序需指定排序的列本回答被提问者采纳
第3个回答 2011-07-27
SELECT * FROM destoon_article_23 WHERE status=3 ORDER BY LIMIT 0,20
--------ORDER BY 后跟的列呢？
加上 应该没问题
--------ORDER BY 后跟的列呢？
加上 应该没问题
第4个回答 2011-07-27
ORDER BY 后 过 应 该 有 排 序 字 段
第5个回答 2011-07-27
SELECT * FROM destoon_article_23 WHERE status=3 ORDER BY LIMIT 20
相似回答
