mysql - 我们可以根据某些条件从同一个表中删除吗？

Question

我尝试执行下面的查询，但它指示 SQL 语法错误:

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 'd1where d1.num='7' and time in (select time from dummy2 d 2 whe' at line 1 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:

有什么建议吗？

请注意，删除操作是在同一个表上执行的。

delete from dummy2 d1 where d1.num='7' and time in (select time from dummy2 d2 where d2.num='5') ;

Answer 1

delete i1.*
FROM dummy2 AS i1
JOIN dummy2 AS i2 ON i2.time = i1.time
WHERE i1.num='7' and i2.num='5';