¥Ì¥ë¤Ï¸À¤¤É餫¤½¤¦¤È¤¹¤ë¤¿¤á¤À¤±¤Ë¸À¤Ã¤Æ¤ë»Ä¹óÌû²÷ÈȤǤ¹¡£
¸À¤¤É餫¤½¤¦¤È¤·¤Æ¤¤¤ë¡¢Áê¼ê¤¬´Ö°ã¤Ã¤Æ¤¤¤ë¤È»×¤¦¤Î¤Ç¤¢¤ì¤Ð¤½¤ÎNULL¤µ¤ó¤È¤È¤³¤È¤ó¼«Ê¬¤ÎǼÆÀ¤¬¤¤¤¯¤Þ¤ÇÏÀ¤¸¤Æ¤ß¤ì¤Ð¤è¤í¤·¤¤¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
·ë¶É²¿¤â¸À¤¤ÊÖ¤¹¤³¤È¤¬½ÐÍè¤Ê¤¤¤Î¤Ç¤³¤ÎËܿͤ¬µï¤Ê¤¤¾ì¤Ç»à¤Í¤È¤«¸À¤Ã¤Æ¤ë¤ó¤Ç¤¹¤è¤Í?
¤¤¤¤¤¿¤¤¤³¤È¤¬¤¢¤ë¤Î¤Ç¤¢¤ì¤ÐËܿͤ˸À¤Ã¤Æ¤ß¤ë¤Î¤¬¤¤¤¤¤È»×¤¤¤Þ¤¹¡£
¤¿¤À¡¢°ì±þÃǤäƤª¤¤Þ¤¹¤¬¡¢¸À¤Ã¤Æ¤ß¤ë¤Î¤¬¡¢¤È¤¤¤¦¤Î¤Ï°ìÊýŪ¤Ê²¡¤·ÉÕ¤±¤Î¤³¤È¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¤è¡£
ÍýÏÀŪ¤ËNULL¤µ¤ó¤ò¤¦¤·¤¯¤¸¤µ¤ó¤¬Ç¼ÆÀ¤¹¤ëÍýÏÀ¤ÇŽ¢ÏÀÇËŽ¥Ç¼ÆÀŽ£¤µ¤»¤Æ¤ß¤Æ¤Ï¤¤¤«¤¬¤Ç¤¹¤«?¤È¤¤¤¦¤³¤È¤Ç¤¹¡£
¤³¤ó¤ÊÅۤϻà¤Í¤è¡£
¤¤¤¤Âç¿Í¤¬²¿¤ò¾®³ØÀ¸¤ß¤¿¤¤¤Ê¤³¤È¸À¤Ã¤Æ¤ë¤ó¤Ç¤¹¤«¡£
Ãæ³ØÀ¸¡¢¹â¹»À¸¤Ç¤â¤½¤ó¤ÊÄ㯤ÊÇÍÀ¼»È¤¦¿Í¾¯¤Ê¤¤¤Ç¤¹¤è¡£
¤â¤¦¤½¤ó¤Ê¤Î¤È¤Ã¤È¤È´¶È¤·¤Þ¤·¤ç¤¦¡£
¤Í¤´¤´¤âËͤΰո«¤ò̵»ë¤·¤ÆÆ±¤¸°Õ¸«¤Î¤´¤ê²¡¤·¤Ê¤É¤Ç¸À¤¤É餫¤½¤¦¤È¤·¤Æ¤Þ¤¹
Ʊ¤¸°Õ¸«¤Î¤´¤ê²¡¤·¤È¤¤¤¦¤³¤È¤ÏŽ¢¤Í¤³¤³¤µ¤ó¤Î¹Í¤¨¤Ï²¿¤¬²¿¤Ç¤â¤½¤¦¤¤¤Ã¤¿¹Í¤¨Ž£¤È¤¤¤¦¤³¤È¤Ç¤¹¤è¤Í¡£
»ä¤Ë¤Ï¤Í¤³¤³¤µ¤ó¤¬¤¦¤·¤¯¤¸¤µ¤ó¤ò¸À¤¤É餫¤½¤¦¤È¤·¤Æ¤¤¤ë¤è¤¦¤Ë¤ÏÅþÄ츫¤¨¤Þ¤»¤ó¤¬¡¢¤½¤¦¸«¤¨¤ë¤Î¤Ç¤¢¤ì¤ÐNULL¤µ¤óƱÍ͹¥¤¤Ê¤À¤±¡¢Ç¼ÆÀ¤¬¤¤¤¯¤Þ¤ÇÏÀ¤¸¤ì¤Ð¤¤¤¤¤Î¤Ç¤¹¡£
¤¢¤Ê¤¿¤Î¹Í¤¨¤ò´ð¤Ë¤Í¤³¤³¤µ¤ó¤Î¹Í¤¨¤òÊѤ¨¤ì¤Ð¤¤¤¤¤Î¤Ç¤¹¡£
¤Ç¤¹¤¬°ìÈÌŪ¤Ë¡¢µÒ´ÑŪ¤Ë¤ß¤ì¤Ð¤Í¤³¤³¤µ¤ó¡¢NULL¤µ¤ó¤Î¸À¤Ã¤Æ¤¤¤ë¤³¤È¼«ÂΤϲ¿¤â´Ö°ã¤Ã¤Æ¤¤¤ë¤³¤È¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
¤¿¤À¡¢NULL¤µ¤ó¤Î¸À¤¦¤È¤ª¤êŽ¢»ö¼Â¤òø¡¹¤È½Ò¤Ù¤Æ¤¤¤ëŽ£¤Ë¤¹¤®¤Þ¤»¤ó¡£
¤·¤«¤·¡¢¤½¤Î¸À¤¤Êý¡¢¤Ê¤¤¤·¤â¤È¤è¤êº¬Ä줬¤ª¤«¤·¤¤¤È»×¤¦¤Î¤Ç¤¢¤ì¤ÐÏÀ¤¸¤Æ¤¯¤À¤µ¤¤¡£
ï¤â»ß¤á¤Þ¤»¤ó¡£
µ¤¤Ë¿©¤ï¤Ê¤¤¡¢Ç¼ÆÀ¤Ç¤¤Ê¤¤¤È¤¤¤¤¤Ä¤Ä¤â·úÀßŪ¤Ê°Õ¸«¡¢¼çÄ¥¤ò¤·¤Ê¤¤¡£
·ë¶É¤¦¤·¤¯¤¸¤µ¤ó¤ÏÀµÏÀ¡¢»ö¼Â¤ò¸À¤ï¤ì¤ÆµÍ¤Þ¤Ã¤¿¤éÇ͸À¡¢¸íËâ²½¤·¤ò»È¤Ã¤ÆÆ¨¤²¤Æ¤¤¤ë¤À¤±¤Ê¤ó¤Ç¤¹¡£
¥¹¥Î¡¼¥Ó¥Ã¥Ä¤µ¤ó¤â¶Ä¤Ã¤Æ¤¤¤Þ¤¹¤¬¼«Ê¬¤ÎÌÀ¤é¤«¤Ë°¤¤¹Ô°Ù¤òê¤Ë¾å¤²¤Æ¼«Ê¬¤Î¤³¤È¤Ð¤«¤ê¼çÄ¥¤¹¤ë¤Î¤Ï¤É¤¦¹Í¤¨¤Æ¤âÍý¤¬Ä̤ê¤Þ¤»¤ó¤è¡£
º£²ó¤³¤Î¥ì¥¹¤Ë¤Æ°ìÈÖÅÁ¤¨¤¿¤¤¤³¤È¤ÏÀÖʸ»ú¤ÎÉôʬ¤Ç¤¹¡£
Ž¥¤½¤ó¤Ê¤ËÁê¼ê¤Î¼çÄ¥¤¬µ¤¤Ë¿©¤ï¤Ê¤¤¤Î¤Ç¤¢¤ì¤Ðµ®Êý¤Î¼çÄ¥¤ò¼´¤È¤·¡¢¹¥¤¤Ê¤À¤±Áê¼ê¤ÈÏÀ¤¸¤ì¤Ð¤¤¤¤
¤È¤¤¤¦¤³¤È¤Ç¤¹¡£
¼«Ê¬¤Î»×¤Ã¤Æ¤¤¤ë¤³¤È¤ò¼çÄ¥¤¹¤ë¤³¤È¤ÏΩÇɤʤ³¤È¤Ç¤¹¤«¤éï¤â»ß¤á¤Ï¤·¤Þ¤»¤ó¤è¡£
¤½¤Î¼çÄ¥¤ò¤·¡¢Áê¼ê¤¬¸À¤Ã¤Æ¤ë¤³¤È¤òÀµ¤·¤¤¤È»×¤¦¤è¤¦¤Ë¤Ê¤ê¡¢¤½¤ì¤ò¼õ¤±Æþ¤ì¤ë¤³¤È¤Ï²¿¤âÃѤº¤«¤·¤¤¤³¤È¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£