呵呵! SELECT * FROM TABLE WHERE COL is NULL 不为空: SELECT * FROM TABLE WHERE COL is not NULL
SELECT * FROM TABLE WHERE COL is NULL
SELECT * FROM TABLE WHERE COL is NULL
SELECT * FROM TABLE WHERE COL is NULL
SELECT * FROM TABLE WHERE isNULL(col)
SELECT * FROM TABLE WHERE col = ''
SELECT * FROM TABLE WHERE COL is NULL
判断是不是为空应该用is或is not不能用=
我总结了一下,下面的都是可以的,还有其他的赶紧加啊: 正确的: 1、select * from TABLE where not COL like '%' 2、SELECT * FROM TABLE WHERE COL is NULL 错误的: 1、SELECT * FROM TABLE WHERE NONULL(COL)=TRUE 2、SELECT * FROM TABLE WHERE isNULL(col) 3、SELECT * FROM TABLE WHERE col = '' 4、SELECT * FROM TABLE WHERE col is ''
SELECT * FROM TABLE WHERE COL is NULL
不为空:
SELECT * FROM TABLE WHERE COL is not NULL
正确的:
1、select * from TABLE where not COL like '%'
2、SELECT * FROM TABLE WHERE COL is NULL
错误的:
1、SELECT * FROM TABLE WHERE NONULL(COL)=TRUE
2、SELECT * FROM TABLE WHERE isNULL(col)
3、SELECT * FROM TABLE WHERE col = ''
4、SELECT * FROM TABLE WHERE col is ''