ÇØ´ç ³¯Â¥ÀÇ ±Û·Î ¹Ù·Î°¡±â
|
ÀÏ
|
¿ù
|
È
|
¼ö
|
¸ñ
|
±Ý
|
Åä
|
|
|
| 1 | 2 | 3 | 4 |
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
|
|
³â
¿ù
ÀÏ
|
³óÇù 777-12-025631
(¿¹±ÝÁÖ: Àü´ëȯ)
|
|
|
|
ÀÌ°÷ÀÇ ±ÛµéÀº ´ë°³ Àü´ëȯÀÇ ÀúÀÛ¹°µéÀÔ´Ï´Ù.
±ÛÀ» »ç¿ëÇϽ÷Á°í ÇÏ´Â °æ¿ì ¹Ýµå½Ã ÀúÀÛÀÚÀÇ Çã¶ôÀ» ¹Þ¾Æ¾ß ÇÕ´Ï´Ù.
Å×ÀÌºí¿¡ ¿ÜºÎ µ¥ÀÌÅÍ ÀúÀåÇϱâ
Å×ÀÌºí¿¡ ¿ÜºÎ µ¥ÀÌÅÍ ÀúÀåÇϱâ |
¸¶À»Áö±â [2006-03-29 15:01]
|
|
[±¸¹®]
load data infile...
[¹®¹ý]
LOAD DATA INFILE 'µ¥ÀÌÅÍÆÄÀÏ°æ·Î' INTO TABLE Å×À̺í¸í FIELDS TERMINATED BY '±¸ºÐÀÚ'
[¿¹½Ã]
mysql> load data infile '/usr/local/data/zipcode.txt' into table zipcode fields terminated by '\t';
[¼³¸í]
¿ÜºÎ µ¥ÀÌÅ͸¦ ÀÏÀÏÀÌ ÀÔ·ÂÇÏÁö ¾Ê°í ÅؽºÆ® ÆÄÀÏ µîÀ¸·Î µÈ °ÍÀ» Åë°·Î ÀԷ½ÃÅ°´Â ¹æ¹ýÀÔ´Ï´Ù. À§ÀÇ ¿¹½Ã´Â ´ÙÀ½°ú °°Àº ¶æÀÔ´Ï´Ù.
"/usr/local/data µð·ºÅ丮¿¡ µé¾î ÀÖ´Â zipcode.txt ÆÄÀÏÀÇ ³»¿ëÀ» zipcode¶ó´Â Å×ÀÌºí¿¡ ÀÔ·ÂÇ϶ó."
|
|
|