删除指定的文章id和文章附表
dr_1_pb
文章标题栏目id表
dr_1_pb_data_0
文章内容附表
DELETE FROM `dr_1_pb` WHERE `id` IN(SELECT id FROM `dr_1_pb_data_0` WHERE `content`="[db:内容1]");
DELETE FROM `dr_1_pb_data_0` WHERE `content`="[db:内容1]";
先删附表再删文章要不内容没了但是对应的id孩子
我就是那个傻子。。。
然后我就又写了一个语句 删除对比两个表中不共存在的id的文章
DELETE FROM dr_1_pb WHERE ID NOT IN (SELECT ID FROM dr_1_pb_data_0);