??????MySQL?е?<=>????????
???????????? ???????[ 2015/1/9 11:51:50 ] ????????MySQL ?????
????· ???? ??
????????????????????????????????
????WHERE p.name <=> NULL
????????????????? <=>????????????????????? =?????????????????????????????????????κδ????????????????????mysql?е? <> = !=??????
????· ???? ??
??????=????????
?????????=??????????????????б????????0???????????1??????;???仰???’A'<=>’B'??0??’a'<=>’a‘??1??
????2.??=???????
??????=?????????????NULL?????????κ???????????=????????????NULL?????Ч????????????????<=>??
????'a' <=> NULL ??0 NULL<=> NULL ?ó? 1????=???????????=????????????? 'a'=NULL ?????NULL ????NULL = NULL ??????NULL?????????mysql????????е???????????????????????????????NULL???????????????塣
????· ???
?????????????????п??????NULL?????????????μ????
????... WHERE col_a <=> ? ...
??????????λ???п??????????п?????NULL???????<=>????????????б????????????κ?????
????· ????????
???????? <=> ???????????????????????????????????NULL?????????IS NULL and IS NOT NULL????????ANSI????е?????????????????????????????С???<=>?????mysql????á?
??????????<=>????mysql?е?????
????'a' IS NULL ==> 'a' <=> NULL
????'a' IS NOT NULL ==> NOT('a' <=> NULL)
???????????????????????θ?????????????
????WHERE p.name IS 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