主页 / 问题 / 561448
Accepted
Joshua
Asked:2020-08-31 21:24:39 +0000 UTC2020-08-31 21:24:39 +0000 UTC

删除请求无效

  • 772

有一个查询成功返回结果：

SELECT * FROM tbl_article_tags t1
       WHERE tag_id = '16256'
       AND EXISTS(SELECT 1 FROM tbl_article_tags t2
                  WHERE t1.article_id=t2.article_id
                  AND tag_id = '17000')

替换SELECT *为DELETE，现在抛出错误：

#1064 - 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 't1 WHERE tag_id = '16256' ' at line 1

有谁知道为什么会这样？

mysql

2 个回答

  1. 工作版本

    DELETE
 FROM tbl_article_tags
       WHERE tag_id = '16256'
       AND EXISTS(SELECT 1 FROM tbl_article_tags t2
                  WHERE tbl_article_tags.article_id=t2.article_id
                  AND tag_id = '17000')
    • 1
  2. Best Answer
    DELETE A.* FROM tbl_article_tags A
  JOIN (
        SELECT id
          FROM tbl_article_tags t1
         WHERE tag_id = '16256'
           AND EXISTS(SELECT 1 FROM tbl_article_tags t2
                       WHERE t1.article_id=t2.article_id
                         AND tag_id = '17000')
       ) B ON A.ID=B.ID

    或者更简单一点：

    DELETE A.* FROM tbl_article_tags A
  JOIN tbl_article_tags B
    ON B.article_id=A.article_id
   AND B.tag_id = '17000'
 WHERE A.tag_id = '16256'

    在你的情况下哪个选项会更快很难说，检查

    • 1

相关问题