mysql - MySQL中的多个DELETE不能与别名一起使用

我将此方案用于多个DELETE

DELETE Table1, Table2, Table3
FROM   Table1
JOIN   Table2 ON (Table2.ConditionID = Table1.ConditionID)
JOIN   Table3 ON (Table3.ConditionID = Table2.ConditionID)
WHERE  Table1.ConditionID = ?;

为什么我不能使用这样的别名

DELETE Table1, Table2, Table3
FROM   Table1 t1
JOIN   Table2 t2 ON (t2.ConditionID = t1.ConditionID)
JOIN   Table3 t3 ON (t3.ConditionID = t2.ConditionID)
WHERE  t1.ConditionID = ?;

我只有一个正常的Syntaxerror。

最佳答案

实际上可以，您只需要使用在ALIAS关键字之后给出的DELETE名称。

DELETE  t1, t2, t3
FROM    Table1 t1
        JOIN   Table2 t2 ON (t2.ConditionID = t1.ConditionID)
        JOIN   Table3 t3 ON (t3.ConditionID = t2.ConditionID)
WHERE   t1.ConditionID = ?;

关于mysql - MySQL中的多个DELETE不能与别名一起使用，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/15971337/