mysql - 在mysql中使用union删除？

Question

我想删除 id = 142。

这两个表是:

1)user_master_activate 2)user_master 表

在两个表具有相同列的情况下使用联合。

DELETE FROM (SELECT * FROM user_master_activate UNION SELECT * FROM user_master ) AS U WHERE (U.id = '142')

this is working where i am getting all users record

  SELECT * FROM (SELECT * FROM user_master_activate UNION SELECT * FROM user_master ) AS U WHERE U.id = '142'

Answer 1

您可以使用以下查询从 user_master_activate 中删除数据:

DELETE FROM user_master_activate WHERE id IN
(SELECT id FROM user_master_activate WHERE id = '142'
 UNION 
 SELECT id FROM user_master WHERE id = '142')

您可以使用以下查询从 user_master 中删除数据:

 DELETE FROM user_master WHERE id IN
(SELECT id FROM user_master_activate WHERE id = '142'
 UNION 
 SELECT id FROM user_master WHERE id = '142')

灵魂2:未测试

DELETE
FROM user_master
    ,user_master_activate USING user_master
INNER JOIN user_master_activate ON user_master.id = user_master_activate.id
WHERE user_master.id = '142';