Mysql 抛出一个错误

Question

DELETE FROM mytable WHERE id IN (SELECT id FROM mytable where roll=1)

我有一个表我的表。我的上述查询引发错误。

不能在 FROM 子句中指定要更新的目标表 'mytable'

Answer 1

来自MySQL documentation :

Currently, you cannot delete from a table and select from the same table in a subquery.

幸运的是，您不需要子查询。只是做:

DELETE FROM mytable WHERE roll=1

启动起来更短更清晰。