????????SQL????????
???????????? ???????[ 2015/12/11 11:48:47 ] ?????????????
?????????????????a not in (b??c??null)??????????
???????????????????д?????????????????????????????????????????е???????塣
????????????????NULL???У???????????μ?????select * from tb where col=null
?????????????????????????????????????col is null ?????????漰??????????
??????????
??????SQL???????????????????TRUE??FALSE??UNKNOWN???????????????????
????????????SQL?????е?????????????????????????TRUE??FALSE???????
????SQL?е?UNKNOWN????????????????NULL???????????У????磬???????????????????UNKNOWN??
????NULL<42;
????NULL=NULL;
????X+NULL>Y;
????UNKNOWN????????????????????????true????false?????????????UNKNOWN????漴????????棬UNKNOWN????true??false?е????????UNKNOWN????????UNKNOWN
??????onwhere??having???????????????UNKNOWN????false????check?б?????true??????????????null???????UNKNOWN??????????а??????CHECK????????salary?е?????????0?????????salary?NULL????????????????NULL>0??????UNKNOWN????check????б??????TRUE?????
???????????б??????NULL??????UNKNOWN??????????false????????????????NULL???????????NULL??
??????UNIQUE???????????????????????????NULL????????
???????????????ж?????UNIQUE??????????????в????????NULL?????С?
????GROUP BY ????????NULL??????顣
????ORDER BY ????????NULL??????????
????????????????????null??????????? is null ????is not null ????????????????????????
???????
???????????????????
????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11