MySql 清理两张表的死数据

1、

mysql如何两个表取差集_mysql 查询两张表的差集

SELECT * FROM ym_message_internal where treatment_id in  
(
SELECT a.treatment_id FROM ym_message_internal a left join LH1030 b on b.LH1030000=a.treatment_id where b.LH1030000 is null
union 
SELECT a.treatment_id FROM ym_message_internal a right join LH1030 b on b.LH1030000=a.treatment_id where a.id is null
)
posted @ 2023-03-06 11:28  一只桔子2233  阅读(14)  评论(0)  编辑  收藏  举报