鍍金池/ 問答/數(shù)據(jù)庫/ 這段sql出錯(cuò)在哪兒,如何解決?

這段sql出錯(cuò)在哪兒,如何解決?

(SELECT *
FROM `dozhan_reply` t1
WHERE `reply_parent` IN (
    SELECT `reply_id`
    FROM (
        SELECT `reply_id`
        FROM `dozhan_reply`
        WHERE `reply_article` = 69
            AND `reply_type` = 0
        LIMIT 0, 5
    ) t
))
UNION
(SELECT *
FROM `dozhan_reply`
WHERE `reply_article` = 69
    AND `reply_type` = 0
LIMIT 0, 5)
UNION
SELECT DISTINCT b1.reply_user, b2.avatar_link
FROM `dozhan_reply` b1, `dozhan_user` b2
WHERE `reply_article` = 69
    AND b1.reply_user = b2.username

圖片描述
求解,搞不懂,語法沒問題呀 ?????

回答
編輯回答
拽很帥

原因:沒有選擇數(shù)據(jù)庫
解決方案:
1.命令行下使用:select dbname;
2.代碼中要配置好項(xiàng)目使用的數(shù)據(jù)庫;

2017年10月12日 22:13