SQLæ°æ®åå¨ä¸ï¼æè°ç空ï¼æ两ç§å½¢å¼ï¼å ·ä½å¦ä¸ï¼
1ãNULLï¼è¿æ¯çæ£æä¹ä¸ç空ï¼åå¦å段å为col1,å¤ææ¹æ³ä¸ºï¼
CASE THEN col1 IS NULL WHEN '为空' ELSE 'ä¸ä¸ºç©º' END2ã空ç½ï¼è¿ç§æ¯è¡¨ç¤ºç©ºç½å符串ï¼åå¦å段å为col1,å¤ææ¹æ³ä¸ºï¼
CASE THEN col1 = '' WHEN '为空' ELSE 'ä¸ä¸ºç©º' END