mysql删除B表中A表不存在的行

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 )