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 ¤¬Ê¸»úÎó"(null)"¤Ë¤Ê¤ë·ï 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]