mysql - 如何从 2 个表中删除特定 "Customer"的所有痕迹？ MySQL

Question

我有 2 个表，Customer 和 Order。

我想删除出现该特定客户的行。我试过了，

DELETE FROM Customer
WHERE Email ='2ManySnakes@gmail.com' -- I was asked to associate the customer with an email. 
UNION
DELETE FROM `Order`
WHERE O_CustomerID = 2;

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

Answer 1

union 用于垂直连接 2 个查询，因此在您的查询中没有意义，您运行 2 个查询是这样的:

DELETE FROM Customer WHERE Email ='2ManySnakes@gmail.com';
DELETE FROM `Order` WHERE O_CustomerID = 2;