mysql删除B表中A表不存在的行
小编:动力软件园 时间:2019-09-08 14:06:02
mysql删除B表中A表不存在的行怎么弄呢下面和小编一起来看mysql删除B表中A表不存在的行详细教程。
删除title为空的数据。
DELETE FROM phome_ecms_pc_check WHERE title =''
删除A表中不在B表的id行
DELETE FROM phome_ecms_pc_check_data WHERE id not in (SELECT id FROM phome_ecms_pc_check )
同上
DELETE FROM phome_ecms_pc_index WHERE id not in (SELECT id FROM phome_ecms_pc_check )
相关阅读
排行榜