1: 查询查看要删除的文章情况的代码:
select * from dede_addonarticle where length(body)<30
2: 删除内容表.
delete from dede_addonarticle where length(body)<30
3: 查询查看要删除的文章情况的第二个表的代码:
select *
from dede_archives t1
left join dede_addonarticle t2 on t1.id=t2.aid
where t2.aid is null
4: 删除第二个表.
Delete dede_archives
from dede_archives t1
left join dede_addonarticle t2 on t1.id=t2.aid
where t2.aid is null