dede_archives
字段名为:
description
里面是空内容的数据, 请问如何写mysql sql语句
4 个解决方案
#1
delete b from dede_addonarticle a ,dede_archives b where a.aid=b.id and a.body is null
#2
delete from dede_archives where description is null;
#3
#4
delete from dede_archives where description is null or description=''
#1
delete b from dede_addonarticle a ,dede_archives b where a.aid=b.id and a.body is null
#2
delete from dede_archives where description is null;
#3
#4
delete from dede_archives where description is null or description=''