[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

mysql:14060

From: "Tetsuro IKEDA" <"Tetsuro IKEDA" <ikdttr@xxxxxxxxxx>>
Date: Sun, 17 Jun 2007 15:18:14 +0900
Subject: [mysql 14060] Re: null ¤¬Ê¸»úÎó"(null)"¤Ë¤Ê¤ë·ï

¤³¤ó¤Ë¤Á¤Ï¡£ÃÓÅĤǤ¹¡£

coalesce´Ø¿ô¤ò»ÈÍѤ·¤Æ¤Ï¤É¤¦¤Ç¤·¤ç¤¦¡©
http://dev.mysql.com/doc/refman/4.1/ja/comparison-operators.html

select coalesce(c1, "") from t1;

¤ß¤¿¤¤¤Ë¤¹¤ë¤È¡¢c1¤ÎÃͤ¬Èónull¤Î¾ì¹ç¤Ï¤½¤ÎÃÍ¡¢null¤Î¾ì¹ç¤Ï¶õʸ»ú¤È¤·¤Æ
ÊÖ¤µ¤ì¤Þ¤¹¡£

07/06/17 ¤Ë akio_takahashi<aaakiotakahasi@xxxxxxxxxx> ¤µ¤ó¤Ï½ñ¤­¤Þ¤·¤¿:
> ´Ä¶­¡§
> ­¡¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¡¡¡¡¡§MS ACCESS2002
> ­¢¥Ç¡¼¥¿¥Ù¡¼¥¹  ¡§MySql4.025
> ­£¥Ç¡¼¥¿¥Ù¡¼¥¹ODBC¡§Mysql ODBC 3.51
> ­¤Mysql¤Î¥µ¡¼¥Ð¤Î¥­¥ã¥é¥¯¥¿¥»¥Ã¥È¡¡ujis
>
> ¤ªÀ¤Ïäˤʤê¤Þ¤¹¡£¸½ºß¡¢MS ¥¢¥¯¥»¥¹¤Ç£Á£Ä£Ï¡¢ ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ï£Í£ù£ó£ñ£ì¤Ç
> ¥³¡¼¥Ç¥£¥ó¥°
> ¤ò¹Ô¤Ê¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£
>
> Î㤨¤Ð¡¢
> ¥Æ¡¼¥Ö¥ë£Á
> ¥Õ¥£¥ë¡¼¥ë¥Éa VARCHAR¡¡NULL¤Ï£Ï£Ë¡Ê¾¤Î¥ª¥×¥·¥ç¥ó¤Ï¤Ä¤±¤Æ¤¤¤Þ¤»¤ó¡Ë
> ¥Õ¥£¡¼¥ë¥Éb¡¡  VARCHAR¡¡NULL¤Ï£Ï£Ë¡Ê¾¤Î¥ª¥×¥·¥ç¥ó¤Ï¤Ä¤±¤Æ¤¤¤Þ¤»¤ó¡Ë
> ¥Õ¥£¡¼¥ë¥Éc    VARCHAR¡¡NULL¤Ï£Ï£Ë¡Ê¾¤Î¥ª¥×¥·¥ç¥ó¤Ï¤Ä¤±¤Æ¤¤¤Þ¤»¤ó¡Ë
>
> ¤Î¥Æ¡¼¥Ö¥ë¤Ç
>
> ¥ì¥³¡¼¥É¤ò£±·ïÄɲä·¤Þ¤¹¡£
> INSET INTO ¥Æ¡¼¥Ö¥ë£Á(¥Õ¥£¥ë¡¼¥ë¥Éa,¥Õ¥£¡¼¥ë¥Éb) VALUES('TEST1','TEST2')
>
> ¥Æ¡¼¥Ö¥ë¤ÎÄɲä·¤¿¥Ç¡¼¥¿¤ÎÃæ¿È¤ò³Îǧ¤·¤Þ¤¹¤È¥Ç¡¼¥¿¤òÄɲ䷤Ƥ¤¤Ê¤¤
> ¥Õ¥£¡¼¥ë¥Éc¤¬Ê¸»úÎó¤Ç"(null)"¤Èɽ¼¨¤µ¤ì¤Þ¤¹¡£
>
> ¼«Ê¬¤È¤·¤Æ¤Ï¶õ¤Î¾õÂ֤ˤʤäƤۤ·¤¤¤Î¤Ç¤¹¤¬¡¢£Í£ù£ó£ñ£ì¦¤Ç¤â¡¢¥¢¥¯¥»¥¹Â¦
> ¤Ç¤âʸ»úÎó¤È¤·¤Æ¥Õ¥£¡¼¥ë¥Éc¤¬Ê¸»úÎó¤Ç"(null)"¤Èɽ¼¨¤µ¤ì¤Þ¤¹¡£
>
> ¤³¤ì¤Ï¥Æ¡¼¥Ö¥ëÄêµÁ¤ä¥­¥ã¥é¥¯¥¿¥»¥Ã¥È¤Ç²ò·è¤Ç¤­¤ë¤Î¤Ç¤·¤ç¤¦¤«¡£
>
> ¤â¤Á¤í¤ó
> INSET INTO ¥Æ¡¼¥Ö¥ë£Á(¥Õ¥£¥ë¡¼¥ë¥Éa,¥Õ¥£¡¼¥ë¥Éb,¥Õ¥£¡¼¥ë¥Éc)
> VALUES('TEST1','TEST2','')
> ¤È¥³¡¼¥Ç¥£¥ó¥°¤¹¤ì¤Ð¥Õ¥£¡¼¥ë¥Éc¤Ï¶õʸ»ú¤Çɽ¼¨¤µ¤ì¤Þ¤¹¤¬¡¢
> ¥Æ¡¼¥Ö¥ë¤Î¥Õ¥£¡¼¥ë¥É¤òÄɲ乤ëÅ٤˥³¡¼¥Ç¥£¥ó¥°¤â¤·¤Ê¤±¤ì¤Ð¤¤¤±¤Ê¤¤¤Î¤Ç
> Èó¸úΨ¤«¤È»×¤¤¤Þ¤·¤¿¡£
>
> ¤ªË»¤·¤¤¤È¤³¤í¡¢ÂçÊѶ²½Ì¤Ç¤¹¤¬¡¢¤É¤Ê¤¿¤«null¤¬Ê¸»úÎó"(null)"¤Ë¤Ê¤ë¸½¾Ý¤¬¤ª
> ¤³¤Ã¤Æ
> ²ò·èÊýË¡¤ò¤É¤¦¤·¤¿¤«ÃΤäƤé¤Ã¤·¤ã¤ëÊý¤¬¤¤¤Þ¤·¤¿¤é¡¢¶µ¤¨¤Æ¤¤¤¿¤À¤±¤Þ¤¹¤Ç
> ¤·¤ç¤¦¤«¡£
>
>
>
> --------------------------------------
> Start Yahoo! Auction now! Check out the cool campaign
> http://pr.mail.yahoo.co.jp/auction/
>
>

[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

     14056 2007-06-17 08:33 [akio_takahashi <aaak] null ¤¬Ê¸»úÎó&quot;(null)&quot;¤Ë¤Ê¤ë·ï 
     14057 2007-06-17 08:56 ¨²[IWASAKI Dai <dai@xxx]                                       
     14058 2007-06-17 09:13 ¨²[Ã鸤 KEN¸ø <ken_ken_]                                       
     14059 2007-06-17 09:45 ¨²[±óÆ£ ½Ó͵ <endo@xxxx]                                       
->   14060 2007-06-17 15:18 ¨±["Tetsuro IKEDA" <ikd]