代码之家  ›  专栏  ›  技术社区  ›  Niczem Olaske

MySQL从AS删除

  •  3
  • Niczem Olaske  · 技术社区  · 11 年前

    我正在尝试从可以通过此查询选择的表中删除某种重复项:

    SELECT * 
      FROM `articles` AS t1 
     WHERE EXISTS (
                    SELECT `id` 
                      FROM articles AS t2 
                     WHERE t2.link = t1.link AND 
                           t2.id > t1.id
                   );
    

    所以我尝试了这两个查询,但它们似乎也不起作用:

    DELETE FROM `articles` AS t1 
    WHERE EXISTS (
                  SELECT `id` FROM articles AS t2 
                   WHERE t2.link = t1.link AND 
                         t2.id > t1.id
                  );
    

    &

    DELETE FROM t1 USING `articles` AS t1 
    WHERE EXISTS (
                  SELECT `id` 
                    FROM `articles` AS t2 
                   WHERE t2.link = t1.link AND 
                         t2.id > t1.id
                  );
    

    两者都返回语法错误。

    2 回复  |  直到 11 年前
        1
  •  3
  •   Mureinik    11 年前

    您可以在 from 条款:

    DELETE t1
    FROM   `articles` t1 , `articles` t2
    WHERE  t2.link = t1.link AND t2.id > t1.id
    
        2
  •  2
  •   tkausl    11 年前
    delete
    from articles using articles,
        articles a1
    where articles.id > a1.id
        and articles.link = a1.link