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

mysql:15390

From: Masaaki Matsuyama <Masaaki Matsuyama <masakun@xxxxxxxxxx>>
Date: Wed, 08 Sep 2010 23:02:45 +0900
Subject: [mysql 15390] Re: ÆÃÄêʸ»úÎó insert »þ¤Ëʸ»ú²½¤±¤¹¤ë

¤Þ¤Ä¤ä¤Þ¤Ç¤¹¡£

> ¡¡¡¡ex '¸Þ½½Íò'¤ò´Þ¤àʸ»úÎó¤òINSERT¤¹¤ëSQL¤ò¼Â¹Ô¤¹¤ë¤È
> ¡¡ ¡¡¡¡ ʸ»ú²½¤±¤·¤ÆÅÐÏ¿¤µ¤ì¤ë¡£

½½¤¬Æþ¤Ã¤Æ¤¤¤Þ¤¹¤è¤Í¡£
¤Ò¤ç¤Ã¤È¤·¤¿¤é¡¢¥·¥Õ¥ÈJIS¤Ç5C¤ò´Þ¤àʸ»ú¤¬²½¤±¤Æ¤¤¤ë¤Î¤Ç¤Ï¡©



-----Original Message-----
From:    ΩÀîÇîÉÒ¡Êmailing¼õ¿®ÍÑ¡Ë <mailing@xxxxxxxxxx>
To:      ml@xxxxxxxxxx
Date:    Wed, 08 Sep 2010 18:49:40 +0900
Subject: [mysql 15388] ÆÃÄêʸ»úÎó insert  »þ¤Ëʸ»ú²½¤±¤¹¤ë

-----

> ½é¤á¤ÆÅê¹Æ¤·¤Þ¤¹¡£
> 
> ´Ä¶­
> 
> ¡ü¥µ¡¼¥Ð¦
> 
> OS : Windows Server 2003
> DB : Mysql 5.0.86-community-nt
> DBʸ»ú¥³¡¼¥É : utf8
> 
> 
> ¡ü¥¯¥é¥¤¥¢¥ó¥È
> 
> OS : Windows XP Professional
>      ACCESS 2007
> ODBC : 3.51.27
> 
> 
> ¡ü¸½¾Ý
> 
> ¡Ê£±¡ËDB¥ª¥Ö¥¸¥§¥¯¥È¤ò»È¤Ã¤ÆODBC·Ðͳ¤ÇľÀÜÀܳ¤·¤Æ
> ¡¡¡¡¡¡varchar ¹àÌܤËINSERTʸ¤ÇÄɲäò¹Ô¤¦¤È¡¢ÆÃÄêʸ»úÎó¤Çʸ»ú²½¤±¤¬
> ¡¡¡¡¡¡µ¯¤­¤¿¤ê¡¢SELECTʸ¤Çvarchar¹àÌܤËÂФ¹¤ë¾ò·ïʸ»úÎó¤¬
> ¡¡¡¡¡¡ÆÃÄêʸ»úÎó¤Î¤È¤­¤Ë¥¨¥é¡¼¤È¤Ê¤êSQLʸ¤¬¼Â¹Ô¤Ç¤­¤Ê¤¤
> 
> 
> ¡¡¡¡ex '¸Þ½½Íò'¤ò´Þ¤àʸ»úÎó¤òINSERT¤¹¤ëSQL¤ò¼Â¹Ô¤¹¤ë¤È
> ¡¡ ¡¡¡¡ ʸ»ú²½¤±¤·¤ÆÅÐÏ¿¤µ¤ì¤ë¡£
> 
> 
> ¡Ê£²¡Ë¤¹¤Ù¤Æ¤Îʸ»ú¤Çʸ»ú²½¤±¤¹¤ë¤ï¤±¤Ç¤Ï¤Ê¤¯¡¢ÆÃÄêʸ»úÎó¤Çµ¯¤­¤ë
> 
> ¡Ê£³¡Ë¥ê¥ó¥¯¥Æ¡¼¥Ö¥ë¤òľÀÜÁàºî¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢Ê¸»ú²½¤±¤Ïµ¯¤­¤Ê¤¤
> 
> ¡¡¡¡¡¡ex ¥ê¥ó¥¯¥Æ¡¼¥Ö¥ë¤ò´ð¤Ë¥Õ¥©¡¼¥à¤òºî¤ê¡¢¥Æ¥­¥¹¥È¥Ü¥Ã¥¯¥¹¤Î
> ¡¡¡¡¡¡¡¡ ¥Ç¡¼¥¿¥½¡¼¥¹¤ËÌäÂê¤Îµ¯¤­¤Æ¤¤¤ë¹àÌܤò³ä¤êÅö¤Æ¤Æ
> ¡¡¡¡¡¡¡¡ ²èÌ̤«¤é¡Ö¸Þ½½Íò¡×¤òÆþ¤ì¤ë¤Èʸ»ú²½¤±¤»¤º¤ËÅÐÏ¿¤Ç¤­¤ë
> 
> 
> ¥Æ¡¼¥Ö¥ë¥ê¥ó¥¯¤·¤¿¾ì¹ç¤È¡¢Ä¾ÀܤĤʤ¤¤À¾ì¹ç¤Ç¡¢ACCESSÆâ¤Ç
> ¤Ê¤Ë¤«¤·¤«¤Î½èÍý¤Î°ã¤¤¤¬¤¢¤ë¤Î¤Ç¤·¤ç¤¦¤«¡©
> 
> ¡¦Á´¤Æʸ»ú²½¤±¤·¤Æ¤¤¤ë¤Ê¤éʸ»ú¥³¡¼¥É¤ÎÌäÂê¤ÈȽÃǤǤ­¤ë¤Î¤Ç¤¹¤¬
> ¡¡ÆÃÄêʸ»úÎó¤Ç¤ª¤­¤Æ¤¤¤ë¤³¤È
> 
> ¡¦SELECTʸ¤Î¾ò·ï¤Ç¤â¡¢ÌäÂ꤬µ¯¤­¤ë¤³¤È¤«¤éSQLʸ¤ËÆÃÄêʸ»úÎó¤¬
> ¡¡Æþ¤Ã¤¿¤È¤­¤Ë¡¢SQL¤Î²òÀϤ˼ºÇÔ¤·¤Æ¤¤¤ë¡©
> 
> ¡¦Àܳ»þ¤Î¥Ñ¥é¥á¡¼¥¿¤¬Â­¤ê¤º¤Ë¤ª¤Á¤Æ¤¤¤ë¤Î¤«¤Ê¤È¤ª¤â¤¦¤¬¡¢
> ¡¡ÆÃÄêʸ»úÎó¤Î¾ì¹ç¤ËȯÀ¸¤·¤Æ¤¤¤ë¡£
> 
> 
> ¤Ê¤É¤Ê¤É¡¢¤Ê¤¾¤À¤é¤±¤Ç¤¹¡£
> 
> ƱÍͤθ½¾Ý¤ò²óÈò¤µ¤ì¤¿·Ð¸³¤Î¤¢¤ëÊý¤¬¤ª¤é¤ì¤Þ¤·¤¿¤é
> À§Èó¡¢ÃηäòÂߤ·¤Æ¤¯¤À¤µ¤¤¡£
> 
> ¤è¤í¤·¤¯¤ª¤Í¤¬¤¤¤·¤Þ¤¹¡£
> 
> 
> 
> 
> 2010.9.8¡¡¤¿¤Á¤«¤ï¤Ò¤í¤È¤·
> 
> 


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

     15388 2010-09-08 18:49 [ΩÀîÇîÉÒ¡Êmailing¼õ¿] ÆÃÄêʸ»úÎó insert  »þ¤Ëʸ»ú²½¤±¤¹¤ë     
   @ 15389 2010-09-08 22:53 ¨²[lime lime <limetibi@]                                       
->   15390 2010-09-08 23:02 ¨²[Masaaki Matsuyama <m]                                       
     15391 2010-09-09 00:24 ¨­¨±[ΩÀîÇîÉÒ¡Êmailing¼õ¿]                                     
   @ 15392 2010-09-10 11:04 ¨±[¤é¤Ã¤Á¤ç ¤é¤Ã¤Á¤ç <z]