"空å¼"æ¯å¯¹nullå¼çä¸æå«æ³ï¼ä¸¤è åæä¸ä¸ªä¸è¥¿ã
å¨ä»£ç é"é¶é¿åº¦å符串"ç¨ä¸å¯¹æ²¡æé´éçè±æå¼å·''表示ï¼å®çæ°æ®ç±»åæ¯æç¡®çå³å±äºå符åï¼åå¨"é¶é¿åº¦å符串"æ¯è¦å ç¨ç©çç£ç空é´çï¼
ènullå¼å ¶æ°æ®ç±»åæ¯æªç¥çï¼å®ä¸ä¼å ç¨ç©çç£ç空é´ã
å¨ä¸åå¨çº¦æéå¶çæ åµæ们å¯ä»¥å°Nullå¼æå ¥ä»»ä½æ°æ®ç±»åçå段éï¼èé¶é¿åº¦å符串''åªè½æå ¥å°å符åæ°æ®ç±»åå段ä¸ï¼æå ¥å ¶å®ç±»åå段ä¼æ¥éã
æ们éè¿å®æµççnullï¼ç©ºå¼ï¼ä¸é¶é¿åº¦å符串''ï¼æ称为空å符é¿ï¼ä¹é´çåºå«ï¼
select * from students;
注æï¼æ¤ä¾è¾åºæºè¡¨ä¸çå ¨é¨è®°å½ï¼å«nullï¼ç©ºå¼ï¼åé¶é¿åº¦å符串''.
select * from students where phone is null;
注æï¼æ¤ä¾åªè¾åºå«Nullï¼ç©ºå¼ï¼çè®°å½
select * from students where phone='';
注æï¼æ¤ä¾åªè¾åºå«é¶é¿åº¦å符串çè®°å½ã
select * from students where phone<>'';
注æï¼æ¤ä¾MySQLçå¤çæ¹å¼æäºç¹å«ï¼è¿å«Nullå¼å¾è®°å½ä¹æé¤æäºï¼è¿ä¸MSSQLçå¤çæ¹å¼æç¹ä¸ä¸è´ã
select * from students where phone is not null;
注æï¼æ¤ä¾åªè¦ä¸å«Nullå¼çè®°å½é½äºä»¥è¾åº