请教批量删除数据库中某个字段为空的记录的语句?!
批量删除数据库中某个字段为空的记录的语句是什么啊?
请指教哦`!
问题点数：0、回复次数：9Top
1 楼hbhbhbhbhb1021（天外水火(我要多努力)）回复于 2005-04-02 11:29:29 得分 0
delete from table where id in (select * from table where 字段 is null)Top
2 楼Fufay（☆梅笑寒☆ MSN: fufay@126.com）回复于 2005-04-02 11:30:28 得分 0
表：
Delete * From TbName Where ColName = ""
Delete From TbName Where ColName is NullTop
3 楼hbhbhbhbhb1021（天外水火(我要多努力)）回复于 2005-04-02 11:35:16 得分 0
DELETE FROM test
WHERE (name IS NULL)Top
4 楼Aspclass（Asp初学者）回复于 2005-04-02 11:36:23 得分 0
不用这么麻烦。。。
可以用updateTop
5 楼madpolice（午夜狂龙）回复于 2005-04-02 11:39:04 得分 0
delete from tb where isnull(字段,'')=''Top
6 楼look4sword（觅剑 | 劈柴、喂马、周游世界。）回复于 2005-04-02 13:57:21 得分 0
Delete * From TbName Where ColName = ""
Delete From TbName Where ColName is Null
Top
7 楼jyzxpboy（小黑努比）回复于 2005-04-02 14:48:35 得分 0
delete from table where id in (select * from table where 字段 is null)
Top
8 楼wangyingdong（初学asp.net）回复于 2005-04-02 18:31:20 得分 0
楼上所说是对的Top
9 楼xiaoyuehen（OH, NO~It's Unfair!）回复于 2005-04-03 00:39:28 得分 0
Delete From TbName Where ColName is Null or ColName = ''Top
