请教批量删除数据库中某个字段为空的记录的语句?!

[99dz31]

批量删除数据库中某个字段为空的记录的语句是什么啊?

请指教哦`!

[look4sword]

Delete * From TbName Where ColName = ""
Delete From TbName Where ColName is Null

[jyzxpboy]

delete from table where id in (select * from table where 字段 is null)

[wangyingdong]

楼上所说是对的

[hbhbhbhbhb1021]

delete from table where id in (select * from table where 字段 is null)

[Fufay]

表：
Delete * From TbName Where ColName = ""
Delete From TbName Where ColName is Null

[hbhbhbhbhb1021]

DELETE FROM test
WHERE (name IS NULL)

[Aspclass]

不用这么麻烦。。。

可以用update

[madpolice]

delete from tb where isnull(字段,'')=''

[xiaoyuehen]

Delete From TbName Where ColName is Null or ColName = ''