mysql - 如何删除基于组合两列的条目

Question

我有一个名为“客户”的表，其中包含 ID、名字、姓氏、电话作为各自的列。

现在我想使用全名从表中删除一个条目。

DELETE FROM customer
WHERE exists (SELECT * Id,CONCAT(Firstname," ",Lastname) as wholename 
           from customer where wholename ="Andre Russel");

Answer 1

尝试:

DELETE FROM customer
WHERE CONCAT(Firstname,' ',Lastname) = 'Andre Russel'