{"id":1219,"date":"2013-03-06T20:46:23","date_gmt":"2013-03-06T20:46:23","guid":{"rendered":"http:\/\/brain.payzip.co.kr\/?p=1219"},"modified":"2013-03-06T20:46:23","modified_gmt":"2013-03-06T20:46:23","slug":"%ed%85%8d%ec%8a%a4%ed%8a%b8%ed%8c%8c%ec%9d%bc-%ec%9a%b0%ed%8e%b8%eb%b2%88%ed%98%b8-db-mysql%ec%97%90-%ec%98%ac%eb%a6%ac%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/blog.goorigo.com\/?p=1219","title":{"rendered":"\ud14d\uc2a4\ud2b8\ud30c\uc77c \uc6b0\ud3b8\ubc88\ud638 DB Mysql\uc5d0 \uc62c\ub9ac\uae30"},"content":{"rendered":"

\uc5ec\uae30\uc11c \uc911\uc694\ud55c\uac70\ub294 \ud14d\uc2a4\ud2b8\ubb38\uc11c\uc778\ub370 \ud30c\uc77c\uc744 \uc62c\ub824\ub193\uaca0\ub294\ub370 \ucd5c\uc2e0\ubc84\uc83c\uc744 \ubc1b\uc744\ub824\uba74 \uc544\uae4c \ub9d0\ud588\ub358 \uc9d1\ud30c\uc778\ub354 \uc0ac\uc774\ud2b8\uac00\uc11c txt\ud30c\uc77c\uc744 \ubc1b\uc544\uc90d\ub2c8\ub2e4. \uc804 \uc0b4\uc9dd \uc774\ud30c\uc77c\uc744 \uc218\uc815\ud588\uc2b5\ub2c8\ub2e4. zipcode_20120126(1) -> zipcode_20120126<\/p>\n

 <\/p>\n

\uc790 \uadf8\ub9ac\uace0 DB\uc5d0\uc11c \uceec\ub7fc\uc744<\/p>\n

 <\/p>\n

1.MYSQL \uc811\uc18d<\/p>\n

 <\/p>\n

2. use \ub514\ube44\u00a0\u00a0\u00a0 : \ub514\ube44 \uc120\ud0dd<\/p>\n

 <\/p>\n

3.\u00a0\uc544\ub798\uc640 \uac19\uc774 MYSQL\uc5d0 \ud14c\uc774\ube14 \uc0dd\uc131<\/p>\n

 <\/p>\n

CREATE TABLE `zipcode` (<\/p>\n

`zipcode` CHAR(7) NOT NULL ,<\/p>\n

`sido` VARCHAR(4) NOT NULL ,<\/p>\n

`gugun` VARCHAR(17) NOT NULL ,<\/p>\n

`dong` VARCHAR(52) NOT NULL ,<\/p>\n

`bunji` VARCHAR(17) NOT NULL ,<\/p>\n

`seq` INT(5) UNSIGNED NOT NULL ,<\/p>\n

PRIMARY KEY (`zipcode`, `seq`) )<\/p>\n

 <\/p>\n

ENGINE = InnoDB<\/p>\n

DEFAULT CHARACTER SET = euckr;<\/p>\n

 <\/p>\n

\uc544\ub798 \ubd80\ubd84\uc740 \uc120\ud0dd \uc0ac\ud56d<\/p>\n

====================<\/p>\n

ENGINE = InnoDB<\/p>\n

DEFAULT CHARACTER SET = euckr;<\/p>\n

===================================<\/p>\n

 <\/p>\n

 <\/p>\n

4.\uba85\ub839\uc5b4 . show databases ; , show tables; \ub85c \ud655\uc778<\/p>\n

 <\/p>\n

 <\/p>\n

5. \uc6b0\ud3b8 \uc0ac\uc774\ud2b8\uc5d0\uc11c \uc6b0\ud3b8 \uc815\ubcf4 \ud30c\uc77c \ub2e4\uc6b4\ub85c\ub4dc<\/p>\n

–\u00a0http:\/\/www.zipfinder.co.kr\/<\/a><\/p>\n

or \ucca8\ubd80\ud30c\uc77c<\/p>\n

 <\/p>\n

 <\/p>\n

6. \ud574\ub2f9 \ud30c\uc77c\uc744 mysql\uc774 \uc124\uce58\ub41c\u00a0\u00a0bin\uc73c\ub85c\u00a0\uc774\ub3d9<\/p>\n

ex ) C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin<\/p>\n

 <\/p>\n

 <\/p>\n

7.\u00a0mysql\ucc3d\uc5d0\uc11c \uc544\ub798 \uba85\ub825\uc5b4 \uc2e4\ud589\u00a0 (\ud30c\uc77c\uc758 \ub370\uc774\ud130\ub97c DB\uc5d0 \ub123\uc74c)<\/p>\n

– load data local infile “zipcode_20120126.txt” into table zipcode;<\/p>\n

 <\/p>\n

 <\/p>\n

=============\ucc38\uace0=========================<\/p>\n

%% \ud55c\uae00\uc774 \uae68\uc9c0\uac70\ub098 ?\ub85c \ub098\uc62c \uacbd\uc6b0<\/p>\n

1. load data local infile “zipcode_20120713.txt” into table zipcode character set euckr;<\/p>\n

2 . set names euckr<\/p>\n

\n

\ub458\ub2e4 \uc9c4\ud589\ud574\uc57c \ud568! \ubc18\ub4dc\uc2dc<\/strong><\/p>\n

==================================<\/strong><\/p>\n<\/div>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\ucc38\uace0 : \uc544\ub798 \uc774\ubbf8\uc9c0<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

 <\/p>\n

8. \ub05d<\/p>\n

 <\/p>\n

\ucd9c\ucc98 :\u00a0http:\/\/blog.naver.com\/PostView.nhn?blogId=huj277&logNo=70150267567<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\uc5ec\uae30\uc11c \uc911\uc694\ud55c\uac70\ub294 \ud14d\uc2a4\ud2b8\ubb38\uc11c\uc778\ub370 \ud30c\uc77c\uc744 \uc62c\ub824\ub193\uaca0\ub294\ub370 \ucd5c\uc2e0\ubc84\uc83c\uc744 \ubc1b\uc744\ub824\uba74 \uc544\uae4c \ub9d0\ud588\ub358 \uc9d1\ud30c\uc778\ub354 \uc0ac\uc774\ud2b8\uac00\uc11c txt\ud30c\uc77c\uc744 \ubc1b\uc544\uc90d\ub2c8\ub2e4. \uc804 \uc0b4\uc9dd \uc774\ud30c\uc77c\uc744 \uc218\uc815\ud588\uc2b5\ub2c8\ub2e4. zipcode_20120126(1) -> zipcode_20120126   \uc790 \uadf8\ub9ac\uace0 DB\uc5d0\uc11c \uceec\ub7fc\uc744   1.MYSQL \uc811\uc18d   2.… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1219"}],"collection":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1219"}],"version-history":[{"count":0,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=\/wp\/v2\/posts\/1219\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1219"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1219"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.goorigo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1219"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}