SQL 语句有关问题(大家来帮帮忙呀)
SQL 语句问题(大家来帮帮忙呀)
表a
ID InPutdate
1 null
2 2005-1-1
inputdate 为日期类型
我根据Inputdate这个字段来检索 Inputdate为空的记录呢?
select * from a where inputedate =null
select * from a where inputedate = ' '我都试过了,都不行呢,大家有什么好办法吗?
小弟谢谢啦
------解决方案--------------------
try select * from a where inputedate is null
------解决方案--------------------
select * from a where inputedate is null
------解决方案--------------------
inputedate is null
------解决方案--------------------
is null
is not null
表a
ID InPutdate
1 null
2 2005-1-1
inputdate 为日期类型
我根据Inputdate这个字段来检索 Inputdate为空的记录呢?
select * from a where inputedate =null
select * from a where inputedate = ' '我都试过了,都不行呢,大家有什么好办法吗?
小弟谢谢啦
------解决方案--------------------
try select * from a where inputedate is null
------解决方案--------------------
select * from a where inputedate is null
------解决方案--------------------
inputedate is null
------解决方案--------------------
is null
is not null