½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
asp
CSS
html
mysql
jquery
image
Mobile
API
slide
°Ô½ÃÆÇ
¸Þ´º
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 87 | Á¶È¸¼ö 1,597 | µî·ÏÀÏ 2003-11-12 10:40:22

´Ð³×ÀÓ

HappyCGI

À̸ÞÀÏ

webmaster@happycgi.com

Á¦¸ñ

[´äº¯] mysqlÀ» ÀÌ¿ëÇÑ ÇÁ·Î±×·¥
³»¿ë
[sunny97´Ô ¿øº»±Û]

¾È³çÇϼ¼¿ä Á¦°¡ ¿¹Àü¿¡ ¾Æ·¡°°Àº Áú¹®À» µå·È¾ú´Âµ¥¿ä.

Á¦°¡ ±×¶§ perl·Î ¼Ò½º¸¦ ¸¸µé¾ú¾ú°Åµç¿ä..

±×·±µ¥.. ±×¶§ mysqlÀ» »ç¿ëÇϸé ÆíÇÒ²¨¶ó°í Çϼ̴µ¥¿ä..

¾Æ·¡°°Àº µ¥ÀÌÅÍ°¡ 2000~3000°³ Á¤µµ·Î ¹«Áö ¸¹À»¶§ ÀÌ°É ¾î¶»°Ô mysqlÀ» ÀÌ¿ëÇØ ¸¸µå³ª¿ä?

2~3000°³ µÇ´Â µ¥ÀÌÅ͸¦ ÀÏÀÏÀÌ sql DB¿¡ ³Ö¾îÁÖ´Â°Ç ¾Æ´Ò²¨°í ¾î¶² ¹æ¹ýÀÌ ÀÖ´ÂÁö ¾Ë·ÁÁÖ¼¼¿ä~~

°¨»çÇÕ´Ï´Ù.

 

*****************************************************************************************8

data.txt´Â ¾Æ·¡°Í

"4","s","vvvvvvv","32A","µµ½Ã°¡½º","¼­¿ïƯº°½Ã","°­³²±¸","³íÇöµ¿"
"5","w","ggggggg","56B","µµ½Ã°¡½º","¼­¿ïƯº°½Ã","µ¿ÀÛ±¸","½Å´ë¹æ1µ¿"
"6","t","yyyyyyy","67B","µµ½Ã°¡½º","Ãæû³²µµ","ûÁÖ½Ã","¿ë¾Ïµ¿"
"6","t","yyyyyyy","67B","µµ½Ã°¡½º","Ãæû³²µµ","ûÁÖ½Ã","ºÒ´çµ¿"
"6","t","yyyyyyy","67B","µµ½Ã°¡½º","Ãæû³²µµ","ûÁÖ½Ã","µÎÁ¤µ¿"
"6","t","yyyyyyy","67B","µµ½Ã°¡½º","°æ»ó³²µµ","ÁøÇؽÃ","¼®µ¿" 




¾È³çÇϼ¼¿ä.. Á¦°¡ ÇÏ°íÀÚ Çϴ°ÍÀº..
À§¿¡ µ¥ÀÌÅ͸¦ °¡Áö°í.http://speedbank.realestate.yahoo.co.kr/Article/?kind=apt_sale 
¿¹¸¦ µé¾î ÀÌ·± ÆäÀÌÁö¸¦ ¸¸µå´Â°ÍÀÔ´Ï´Ù.
óÀ½¿£ ¼­¿ïƯº°½Ã Ãæû³²µµ °æ»ó³²µµ ÀÌ·¸°Ô ³ª¿À°Ô Çϱ¸¿ä. index.html¿£..
µÎ¹ø° sub.html¿£ ¼­¿ïƯº°½Ã¸¦ ´­·¶À»¶§´Â °­³²±¸ µ¿ÀÛ±¸ µîÀÌ »Ñ·ÁÁ®¾ß ÇÕ´Ï´Ù.
 
ÀÌ·±½ÄÀ¸·Î ÆäÀÌÁö ±¸¼ºÀ» Çϴ°ÍÀ» perl·Î ©·Á°í Çϴµ¥¿ä~
¾Æ·¡±îÁö ®´Âµ¥ ±× ´ÙÀ½.. ÀÌ °ªµéÀ» ¾î¶»°Ô ÇØ¾ß Çϴ°ǰ¡¿ä?
 
¾Æ½Ã¸é Á» ¾Ë·ÁÁÖ¼¼¿ä -_-;;
 
 

 

ÇØÇÇCGI ÀÔ´Ï´Ù.

mysql¿¡ ¿ì¼± DB¿Í Å×À̺íÀÌ txt Çü½Ä¿¡ ¸Âµµ·Ï Â¥¾ß ÇÏ°Ú±¸¿ä.

±×°Ô ÀÖ´Ù°í °¡Á¤À» ÇÒ¶§ data.txt ÆÄÀÏÀº sql¿¡ ¾Æ·¡ ó·³ ³ÖÀ¸½Ã¸é µË´Ï´Ù.

mysql Á¢¼ÓÇÑ »óÅ¿¡¼­


[ÇÁ·Î±×·¥ÄÚµå]

LOAD DATA INFILE '°æ·Î¸í/ÆÄÀϸí' REPLACE INTO TABLE Å×À̺í¸í FIELDS TERMINATED BY '\t';

À§ ó·³ ÀÔ·ÂÀ» ÇØÁÖ½Ã¸é µË´Ï´Ù.

ÁÁÀº ÇÏ·çµÇ¼¼¿ä.


 

Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
ÀÌÀü°Ô½Ã±Û php¿Í mysql ·Î ¸¸µå´Â Ä«¿îÅÍÁ»... ¤Ð¤Ð 2003-11-12 02:18:20
´ÙÀ½°Ô½Ã±Û php·Î ±¸ÇöÇϱâ. 2003-11-13 21:37:54