??????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