mysql - 如何从2个表中删除特定“客户”的所有跟踪记录？的MySQL

我有两张桌子，顾客和订单。
我希望删除该特定客户出现在其中的行。我试过了，

DELETE FROM Customer
WHERE Email ='[e-mail]' -- I was asked to associate the customer with an email.
UNION
DELETE FROM `Order`
WHERE O_CustomerID = 2;

不确定这是否可行。但我只想知道语法是否正确。

最佳答案

union用于垂直连接两个查询，因此在查询中没有意义，您可以运行以下两个查询：

DELETE FROM Customer WHERE Email ='[e-mail]';
DELETE FROM `Order` WHERE O_CustomerID = 2;