¸¶½ºÅÍÆ÷À¯(Master4U)
Monday, 17 of January
 

·Î±×ÀÎ Category
MySQL¿¡¼­ CSV ¿Ã¸®±â, »Ì¾Æ³»±â
°ü¸®ÀÚ  2008-02-10 14:26:05 Hit:5610
¸µÅ© #1: http://blog.naver.com/neoi?Redirect=Log&logNo=120012933124

mysql¿¡ csv ÆÄÀÏ ¿Ã¸®±â

mysql

2005/05/04 01:05

  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

 

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 >

º»¹®Àμ⺻¹®¸ÞÀϹ߼Û
¡â [Mysql] ÀÚÁÖ¾²´Â ¸í·É Á¤¸®
¡ä mysql 4.1.1 alpha ¿¡¼­ ÇÑ±Û Á¦´ë·Î ¼³Á¤Çϱâ
Copyright 1999-2025 Zeroboard / skin by ChanBi