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

mysql:15644

From: "ochiai" <"ochiai" <s.ochiai@xxxxxxxxxx>>
Date: Tue, 8 Nov 2011 10:14:56 +0900
Subject: [mysql 15644] Re: CSV¥Õ¥¡¥¤¥ë¤Î¥¤¥ó¥Ý¡¼¥È¤Ë¤Ä¤¤¤Æ¼ÁÌä

¤È¤ß¤¿ÍÍ¡¢³Æ°Ì

¤È¤ß¤¿Íͤ´Äó°Æ¤Î¡ÖCHARACTER SET sjis ¤ò CHARACTER SET cp932 ¤Ë¤·¤Æ¤ß¤¿¤é¡×¡¢¸½¾Ý¤¬ÊѤï¤ê¡¢¥¤¥ó¥Ý¡¼¥È¤Ç¤­¤Þ¤·¤¿¡£

¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£
¤Ê¤ª¡¢º£¤Þ¤Ç¤â¥ï¡¼¥¯¥Ù¥ó¥Á¤Î¡ÖOpen a SQL script File¡×¤ò¥¯¥ê¥Ã¥¯¤·INFILE¤òÁªÂò¤·¡¢³«¤¯¥Ü¥¿¥ó¤ò¥¯¥ê¥Ã¥¯¤·¤¿»þ¤Ë¡ÖUnknownFileEncoding¡×¡Ê¥­¥ã¥é¥¯¥¿¥»¥Ã¥È¥¨¥ó¥³¡¼¥Ç¥£¥ó¥°Ì¾¤ò»ØÄꤹ¤ë²èÌ̡˽ФƤ¤¤Þ¤·¤¿¡£
º£¤Þ¤Ç¤Ï¡¢sjis¤ÈÆþÎϤ·OK¥Ü¥¿¥ó¤ò²¡¤·¤Æ¤¤¤Þ¤·¤¿¤¬¡¢º£²ó¤Ï¤³¤³¤Ç¤âcp932¤ÈÆþÎϤ·OK¥Ü¥¿¥ó¤ò²¡¤·¤Þ¤·¤¿¡£
ÅöÁ³¡¢SQL¥¹¥¯¥ê¥×¥È¤Ç¤Ï¤´Äó°Æ¤ÎÄ̤ꡢcp932¤È¤·¤Æ¼Â¹Ô¤·¤Þ¤·¤¿¡£

²þ¤á¤Æ¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£

> ¤È¤ß¤¿¤Ç¤¹¡£
>
> On Fri, 4 Nov 2011 14:44:54 +0900
> "ochiai" <s.ochiai@xxxxxxxxxx> wrote:
>
>> °Ê²¼¤ÎÄ̤ꡢLOAD DATA¥³¥Þ¥ó¥É¤ò¥µ¡¼¥Ð¾å¤Ç¥ï¡¼¥¯¥Ù¥ó¥Á¤«¤é¼Â¹Ô¤·¤Þ¤·¤¿¤¬¡¢¥ï¡¼¥Ë¥ó¥°¤¬1¤Ä½Ð¤Æ¡¢¥Ç¡¼¥¿¤Ï1¹Ô¤â¥¤¥ó¥Ý¡¼¥È¤µ¤ì¤Þ¤»¤ó¡£
>> ¥¤¥ó¥Õ¥¡¥¤¥ë¤â¥³¥Þ¥ó¥É¤âƱ¤¸¤Ê¤Î¤Ë¡¢¤¦¤Þ¤¯¥¤¥ó¥Ý¡¼¥È¤Ç¤­¤¿¤³¤È¤â¤¢¤ë¤Î¤Ç¤¹¤¬¡¢¤Û¤È¤ó¤É¤¬¤À¤á¤Ç¡¢²¿¤¬¤¤¤±¤Ê¤¤¤Î¤«¡¢º¤¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£
>>
>> ¡ãºî¶ÈÆâÍÆ¡ä
>> LOAD DATA LOCAL INFILE 'C:/ProgramData/MySQL/...../infile.csv'
>>     INTO TABLE s1.tbl1
>>     CHARACTER SET sjis
>>     FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
>>     LINES TERMINATED BY '\r\n'
>>     IGNORE 1 LINES
>>     (
>>      recordNo,
>>      col1,
>>      col2
>>      );
>
> Á´Á³¤Ï¤º¤·¤Æ¤ë¤«¤â¤·¤ì¤Ê¤¤¤ó¤Ç¤¹¤¬¡¢CHARACTER SET sjis ¤ò CHARACTER
> SET cp932 ¤Ë¤·¤Æ¤ß¤¿¤é¡¢¸½¾Ý¤¬¤«¤ï¤Ã¤¿¤ê¤·¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
>

¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á
³ô¼°²ñ¼Ò ÂçÍβèÃÏ¡¡
ÅÔ»Ô¾ðÊóÉô¡¡µ»½Ñ¸ÜÌä¡¡Íî¹ç¡¡»ÊϺ
¢©332-0031¡¡Àî¸ý»ÔÀÄÌÚ4¡Ý7¡Ý3
­ä¡§048-257-1100
fax¡§048-257-1353
e-mail¡§s.ochiai@xxxxxxxxxx
URL¡§http://www.taiyokakuchi.co.jp
¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á¡á 


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

     15641 2011-11-04 14:44 ["ochiai" <s.ochiai@x] CSV¥Õ¥¡¥¤¥ë¤Î¥¤¥ó¥Ý¡¼¥È¤Ë¤Ä¤¤¤Æ¼ÁÌä     
     15642 2011-11-04 19:08 ¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm]                                       
->   15644 2011-11-08 10:14 ¨­¨±["ochiai" <s.ochiai@x]                                     
     15643 2011-11-05 00:05 ¨±[SAKAI Kei <sak2@xxxx]                                       
     15645 2011-11-08 10:53 ¡¡¨±["ochiai" <s.ochiai@x]                                     
     15646 2011-11-08 17:20 ¡¡¡¡¨±[ÃæÀîµ® <nora1962@xxx]