À̱ÛÀº
http://phpschool.com/bbs2/inc_view.html?id=36429&code=database2
¿¡¼ ´äº¯ÇÑ ±ÛÀ» °¡Á®¿Â ±ÛÀÔ´Ï´Ù.
>[Á¦¸ñ] load infile~~ ÇÒ¶§, ÀÌ·± °æ¿ì ¾î¶»°Ô ÇؾßÇÏÁÒ
>[±Û¾´ÀÌ] ÇìÁÙ·¿
>
>Á¦°¡ txtÆÄÀÏ·ç,, ¾Æ·¡¿Í °°ÀÌ ³ÖÀº´Ù°í °¡Á¤Çغ¸°Ù½À´Ï´Ù.
>
>1 | ±èÀϳ² | ³²ÀÚ | 22
>2 | ±èÀ̳à | ¿©ÀÚ | 27
>3 | ±è»ï³² | ³²ÀÚ | 23
>4 | ±è»ç³² | ³²ÀÚ | 21
>
>À̶§, Å×À̺íÀº ¾Æ·¡ Á¤Àǹ®ÀÔ´Ï´Ù.
>create table test (
> mb_uid int(15) not null auto_increment ,
> mb_name varchar(60) not null ,
> mb_age tinyint(3) unsigned not null ,
> primary key (mb_uid)
>);
>
>ÀÌ °°ÀÌ Á¤ÀÇÇÏ°í,, load infile±¸¹®À» ÅëÇØ,, ÀúÀåÇÏ·Á°í ÇÕ´Ï´Ù.
>
>¹®Á¦´Â txt´Â ÁÙº¯ ±¸ºÐÀÚ°¡ ( | )·Î ±¸ºÐµÇ¾î Àִµ¥, ºÒÇÊ¿äÇÑ°ÍÀº
>1 | ±èÀϳ² | ³²ÀÚ | 22
>-- ------ ---- --
>ÇÊ¿ä ÇÊ¿ä ºÒÇÊ¿ä ÇÊ¿ä
>
>¼ºº°ºÎºÐÀ̳׿ä..
>load infile~ÇÒ °æ¿ì ¼ø¼´ë·ç ÀоîµéÀ̴µ¥,, À§ ³²ÀÚ±îÁöÀÇ ³»¿ë¸¸ Å×ÀÌ>ºí¿¡
ÀúÀåÇѴٴ°ÅÁÒ..
>ÀÌ°Å.. ¿øÇÏ´Â ÇüÅ·ç, ¼ºº°¿¡ ÇØ´çµÇ´Â µ¥ÀÌÅ͸¦ »©±¸, ³ª¸ÓÁö °íÀ¯¹øÈ£,
>À̸§, ³ªÀ̸¸,, ³Ö´Â ¹æ¹ýÁ» ¾Ë·ÁÁÖ¼¼¿ä..
>±×·³ ÁñÀϵǼ¼¿ä..
>
=============================
»óÀ§ÀÇ text ÆÄÀÏÀº °£´ÜÇϹǷΠ½±°Ô ¼öÁ¤ÀÌ °¡´ÉÇϳ׿ä
shell> sed 's/|\(³²ÀÚ\|¿©ÀÚ\)|/|/gi'
data.txt > data.new.txt
±×¿Ü...
text ÆÄÀÏ¿¡¼ Á÷Á¢ ¼öÁ¤Çϱâ Èûµé´Ù¸é ´ÙÀ½ÀÇ ¹æ¹ýÀ» »ç¿ëÇØ º¸¼¼¿ä.
¿ì¼± txt ÆÄÀÏÀÇ ÀÚ·á Ä÷³¼ö°ú table Ä÷³¼ö°¡ ¼·Î °°°Å³ª table Ä÷³¼ö°¡
´õ ¸¹¾Æ¾ß ÇÕ´Ï´Ù.
±×·±µ¥,
ÇöÀç »óȲÀÌ ±× ¹Ý´ëÀ̹ǷΠtable¿¡¼ ƯÁ¤ Ä÷³À» Ãß°¡ÇØÁÖ¾î¾ß ÇÕ´Ï´Ù.
[table¿¡ Àӽà mb_sex Ä÷³ Ãß°¡]
mysql> ALTER TABLE test ADD mb_sex varchar(4) NULL AFTER mb_name;
[µ¥ÀÌÅÍ ÀÔ·Â]
mysql> LOAD DATA LOCAL INFILE '/path/to/data.txt' INTO TABLE test
> FIELDS TERMINATED BY '|';
[mb_sex Ä÷³ »èÁ¦]
mysql> ALTER TABLE test DROP mb_sex;
ÀÌ·±½ÄÀ¸·Î ÇÏ¸é µË´Ï´Ù
|