MySQL联查
联表查询
联查结果删除
1. t1,t2有关联 t2为where条件 删除t1
DELETE t1 FROM dictionary_detail t1 LEFT JOIN dictionary t2 ON t1.dictionary_id = t2.id WHERE t2.id IS NULL;
MySQL联查
发布时间 2023-03-24 11:05:31作者: 晚冬十五
DELETE t1 FROM dictionary_detail t1 LEFT JOIN dictionary t2 ON t1.dictionary_id = t2.id WHERE t2.id IS NULL;