|
|
|
Áú¹®°ú ´äº¯
|
|
* ¸Å´º¾ó°ú ÀÚÁÖ ¹¯´Â Áú¹®À» ¸ÕÀú È®ÀÎ ÇϽðí, Áú´ä °Ô½ÃÆÇ¿¡¼ °Ë»öÈÄ Áú¹®¹Ù¶ø´Ï´Ù.
* Áú¹®½Ã¿¡´Â ÀÚ½ÅÀÇ °èÁ¤ ¾ÆÀ̵ð¿Í ȨÁÖ¼Ò¸¦ ÇÊÈ÷ ³²°ÜÁֽñ⠹ٶø´Ï´Ù.
* ¿¡·¯·Î ÀÎÇÑ ¹®Àǽà ¿¡·¯¸Þ¼¼Áö¸¦ ÇÊÈ÷ ÇÔ²² ³²°ÜÁֽñ⠹ٶø´Ï´Ù.
* Áú´ä °Ô½ÃÆÇÀº °ø°³°Ô½ÃÆÇÀ¸·Î °èÁ¤ ºñ¹Ð¹øÈ£ Á¤º¸¸¦ ³²±â½Ã¸é ¾ÈµË´Ï´Ù.
|
Read Reply from No. 39503 article |
2015-06-21 23:11:15 |
|
|
|
|
NickName |
Ç®ºñ´© |
Subject |
Re: ¿î¿µÀÚ´Ô ¼ö°í ¸¹À¸¼¼¿ä. |
|
|
phpmyadmin ¿¡¼ load data ±¸¹®ÀÌ ½ÇÇàÀÌ µÇÁö ¸øÇÕ´Ï´Ù.
ftp ·Î ÇØ´ç txt ÆÄÀÏÀ» ¾÷·Îµå ÇϽÅÈÄ¿¡,
ssh Á¢¼ÓÇÏ¿©, µðºñ Á¢¼ÓÈÄ ¸í·ÉÀ» Á÷Á¢ ÀÔ·ÂÇØ º¸½Ã±â ¹Ù¶ø´Ï´Ù.
LOAD DATA LOCAL INFILE '/home1/ftpid/filename.txt' REPLACE INTO TABLE [db.table.name] FIELDS
TERMINATED BY '|';
°¨»çÇÕ´Ï´Ù.
joylife wrote..
: ´Ù¸§ÀÌ ¾Æ´Ï¶ó
: phpadmin¿¡¼ ImportÅÇ¿¡¼ File to import·Î ÁÖ¼Ò°¡ ´ã±ä txtÆÄÀÏÀ» ¾÷·Îµå½ÃÄÑ
: ½ÇÇàÀ» ´©¸£´Ï ¾Æ·¡¿Í °°Àº ¿¡·¯°¡ ³ª¿É´Ï´Ù.
: ==============================================================================================
: ¿À·ù
: SQL ÁúÀÇ:
:
: LOAD DATA INFILE '/dev/shm/phphbCFfm' INTO TABLE `juso` FIELDS TERMINATED BY ',' ESCAPED BY
: '\\' LINES TERMINATED BY '\r\n'
:
: MySQL ¸Þ½ÃÁö: µµ¿ò¸»
:
: #1045 - 'stylefix@localhost' »ç¿ëÀÚ´Â Á¢±ÙÀÌ °ÅºÎ µÇ¾ú½À´Ï´Ù. (Using password: ¿¹)
: ==============================================================================================
: À߸øµÈ ºÎºÐÀ» ¼ÕÀ» µ¥¾ß ÇØ°á °¡´ÉÇѰ¡¿ä?
[ °ü·Ã±Û ]
|
|
Page Loading [ 0.49 Sec ]
SQL Time [ 0.46 Sec ]
|
|
|