ÅؽºÆ®¸¦ DB¿¡ ³ÖÀ»¶§ Áú¹® µå¸³´Ï´Ù.

   Á¶È¸ 6455   Ãßõ 0    

mysql -u root -p passwd DB_name -e "delete from table_name;

load data infile 'a.txt' into table table_name fields terminated by '\n' lines terminated by '\r\n' (Çʵå1,Çʵå2,Çʵå3);

load data infile 'b.txt' into table table_name fields terminated by '\n' lines terminated by '\r\n' (Çʵå4,Çʵå5,Çʵå6);

load data infile 'c.txt' into table table_name fields terminated by '\n' lines terminated by '\r\n' (Çʵå7,Çʵå8,Çʵå9);

load data infile 'd.txt' into table table_name fields terminated by '\n' lines terminated by '\r\n' (Çʵå10,Çʵå11,Çʵå12);

load data infile 'e.txt' into table table_name fields terminated by '\n\n' lines terminated by '\r' (Çʵå13,Çʵå14,Çʵå15); "



Å×À̺íÀº Çʵå1,Çʵå2Çʵå3......Çʵå14,Çʵå15 ·Î ±¸¼ºµÇ¾îÀÖ½À´Ï´Ù.

À§Àǹæ¹ýÀ¸·Î Çϴϱñ ÇàÀÌ ´Ù ³ª´²Áö´øµ¥...textÆÄÀÏÀº a,b,c,d,e ´Ù¼¸°³Àε¥ text¸¦ DB·Î ³ÖÀ»¶§ ¿©·¯ÆÄÀÏÀ» ÇÑÅ×ÀÌºí¿¡ ³ÖÀ¸¸é¼­ ÇÑÇà¿¡ ÂÒ¾Ç ³Ö´Â ¹æ¹ýÀÌ ¾øÀ»±î¿ä?
서버 모니터링, 라즈베리파이에 관심이 많습니다.
http://www.sproc.co.kr
http://rpi.sproc.co.kr
http://noaa.sproc.co.kr
ªÀº±Û Àϼö·Ï ½ÅÁßÇÏ°Ô.
±è»óÁø 2010-02
À½....Àú¶ó¸é, ±×³É 5°³ ÆÄÀÏÀ» Àӽà Å×À̺í·Î °¢°¢ ³ÖÀº´ÙÀ½¿¡
5°³ Å×À̺íÀ» Á¶ÀÎÇؼ­ ÇϳªÀÇ Å×À̺í·Î ¸¸µé´ø ¾Æ´Ô view¸¦ ¸¸µå´Â ¹æ¹ý´Â ¾î¶³·±Áö¿ä
´Ù¸¸, ¾çÀÌ ¸¹´Ù¸é joinÇؼ­ insertÇϴ°͵µ ºÎÇÏ°¡ Å©±äÇÏÁÒ ^^
¶ÇÇÑ, °¢°¢ 5°³ Å×À̺íÀ» joinÇϱâÀ§ÇÑ Å°°ªµéÀº º°µµ·Î °¡Áö°íÀÖ¾î¾ß °ÚÁÒ

¾Æ´Ï¸é, editer¿¡¼­ Çϳª·Î ÇÕÄ¡´Â ¹æ¹ýµµ ÀÖ±äÇѵ¥...(unixÀÇ ½©·Îµµ °¡´ÉÇÒ·±Áö´Â ¸ð¸£°ÚÁö¸¸) ^^


QnA
Á¦¸ñPage 3881/5692
2014-05   5017561   Á¤ÀºÁØ1
2015-12   1552969   ¹é¸Þ°¡
2014-09   4585   À嵿°Ç2014
2016-01   4402   È£µ¹1735
2010-02   6456   °æ¹ÚÇѽùÎ
2021-11   1696   °Ü¿ï³ª¹«
2014-09   13813   Astarot
2016-01   3390   Çູ´ÜÁö
2018-02   6878   thetoys
2020-07   3697   Àϸ®ÄÉ
2023-06   2343   ¸ÞÅ»Æ÷½º
2019-04   310   ¸¶ÆÐ
2018-02   3897   ±èÈÆ1
2023-07   3037   ¼ÛÀç
2013-04   7400   Æù³×¼Ò½º
2014-10   4735   ¾Æħ¹î»ì
2019-04   3341   »ßµ¹À̽½ÇÄÀÌ
2020-07   3227   ÀÌÁ¾Çöoph
2013-04   27866   song05
2013-04   12783   ÀÌÁöÆ÷Åä
2018-03   3274   ¼¼¿¡¶ó
2020-07   2798   ÀüÁø