mysql¿¡ csv ÆÄÀÏ ¿Ã¸®±âmysql
2005/05/04 01:05
http://blog.naver.com/neoi/120012630796
CSVÆÄÀÏÀ» ³Ö´Ù°¡ º¸¸é ´ÙÀ½°ú °°Àº ¿¡·¯¸Þ½ÃÁö¸¦ ¸¸³ª°Ô µË´Ï´Ù.
- ERROR 1105: File './ÆÄÀϸí.csv' not found (Errcode: 2) ¶Ç´Â - Error 13: Can't get stat of 'ÆÄÀϸí.csv'' <Errcode:2>
ÀÌ·±½ÄÀÇ ¿¡·¯°¡ ³¯¶§´Â ¹«Ã´ ´çȲ ½º·´½À´Ï´Ù. Àúµµ ÀÌÁ¦¾ß ÀڷḦ ã¾Æ³»¼ ÇØ°á Ç߳׿ä.
°¡Àå Å« ¹®Á¦´Â MYSQL¿¡¼ ÇØ´ç ÆÄÀÏÀ» ãÀ» ¼ö°¡ ¾ø´Ù´Â °ÅÁÒ
MYSQLÀº MYSQL µ¥ÀÌÅÍ µð·ºÅ丮¸¸À» ÀÐÀ» ¼ö ÀÖ°Ô ¼³Á¤µÆÀ» °æ¿ì ´Ù¸¥ Æú´õ¿¡ ³Ö°í
¾Æ¹«¸® chmod 777 À» Á־ °á±¹ ¼î¸¸ ÇÏ´Â ²ÃÀÌ µË´Ï´Ù.
°á±¸ mysql µ¥ÀÌÅÍ µð·ºÅ丮¿¡ ³Ö¾î¼ ÇØ°áÀ» ÇØ¾ß °Ú½À´Ï´Ù. ´ÙÀ½°ú °°ÀÌ µû¶ó ÇÏ½Ã¸é º° ¹®Á¦ ¾øÀ¸¸®¶ó »ý°¢µË´Ï´Ù.
1. CSVÆÄÀÏÀ» ¸¸µçÈÄ ÅÚ³ÝÀ¸·Î ¹Ýµå½Ã mysql°èÁ¤À¸·Î Á¢¼Ó ÇÑ´Ù. 2. mysqlÀÇ dataµð·ºÅ丮(/usr/local/mysql/data) Æú´õ·Î csvÆÄÀÏÀ» ¾÷·ÎµåÇÑ´Ù. (mysql°èÁ¤ÀÌ ¾Æ´Ï¸é ¾÷·Îµå°¡ ¾ÈµÊ) 3. telnetÀ¸·Î Á¢¼ÓÇÑ´ÙÀ½ mysql °èÁ¤À¸·Î À¯Àú¸¦ º¯°æÇÑ´Ù 4. csvÆÄÀÏÀÌ ÀÖ´Â mysqlÀÇ dataµð·ºÅ丮 Æú´õ·Î À̵¿ÇÑ´Ù. 5. mysqlÁ¢¼Ó ÈÄ sql¹®À» ½ÇÇà ÇÑ´Ù. LOAD DATA INFILE "/mysqlµð·ºÅ丮°æ·Î/ÆÄÀϸí.csv" INTO TABLE Å×À̺í¸í FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' (Ä÷³¸í1, Ä÷³¸í2, Ä÷³¸í3, Ä÷³¸í4, Ä÷³¸í5, Ä÷³¸í6) 6. µ¥ÀÌÅ͸¦ È®ÀÎÇÑ´Ù
ÀÚ·áÃâó : http://blog.naver.com/neoi?Redirect=Log&logNo=120012933124 >
mysql¿¡¼ csv·Î »Ì¾Æ ³»±âmysql
2005/05/03 23:51
http://blog.naver.com/neoi/120012628475
1. ÇѰ³ Ä÷³À» csvÆÄÀÏ·Î »Ì¾Æ³»´Â Äõ¸® ÀÔ´Ï´Ù.
SELECT (Ä÷³¸í) INTO OUTFILE "e:/ÆÄÀϸí.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM Å×À̺í¸í;
2. Àüü µ¥ÀÌÅÍ csv ÆÄÀÏ·Î »Ì±â
SELECT * INTO OUTFILE "e:/ÆÄÀϸí.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM Å×À̺í¸í;
3. ƯÁ¤ Ä÷³ µ¥ÀÌÅÍ csv ÆÄÀÏ·Î »Ì±â
SELECT Ä÷³¸í1, Ä÷³¸í2, Ä÷³¸í3, Ä÷³¸í4 INTO OUTFILE "e:/ÆÄÀϸí.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM Å×À̺í¸í;
<ÀÚ·áÃâó : http://blog.naver.com/neoi?Redirect=Log&logNo=120012933124 >
|