Áö±Ý tolinux.net ¿¡ µðºñ´Â ÃֽŠÀÚ·á·Î º¯°æµÈ ÀÚ·áÀÓ.
cysql Æú´õ ¾Æ·¡¿¡ csv ÆÄÀÏÀÌ À§ »çÀÌÆ®¿¡¼ ¹èÆ÷ÇÏ´Â ¹øÁö ºÐ¸®Çü ÁÖ¼Ò¸¦ ¹Þ¾Æ¼ csv ·Î º¯°æÇÑ ÀÚ·áÀÓ.
tolinux.net ÀÇ zipcode Å×À̺í°ú ±¸Á¶¿Í ¼ø¼°¡ µ¿ÀÏÇϹǷΠ±×´ë·Î Àû¿ëÇÏ¸é µÈ´Ù.
load data infile '/home/nig0412/www/cyboard/cysql/20130201_zipcode.csv' replace into table zipcode fields terminated by ',';
|