mysql - 不能在 MARIADB 的删除语句中使用 ALIAS

Question

我正在尝试从表中删除重复项，但不允许我使用别名。尝试了多个论坛中提供的各种解决方案。

查询是，

DELETE FROM `table` AS t1
        WHERE EXISTS (
         SELECT 1 FROM `table` AS t2
         WHERE t2.`col1` = t1.`col1`
         AND t2.`col2` = t1.`col2`
         AND t2.id > t1.id )

Answer 1

可以使用多表DELETE声明:

DELETE t1 
FROM `table` t1
JOIN `table` t2 ON t2.col1 = t1.col1 AND t2.col2 = t1.col2 AND t2.id > t1.id