Mysql 에 우편 번호 넣는방법.

zipcode.csv

 다운받을 파일을 D 드라이브에  위치시킨다.

 

--------------------------테이블 생성 코드 -------------------------- 

CREATE TABLE ZIPCODE (
ZIPCODE VARCHAR(7),
SIDO    VARCHAR(4),
GUGUN   VARCHAR(17),
DONG    VARCHAR(26),
RI      VARCHAR(45),
BUNJI   VARCHAR(17),
SEQ     INT
);
 

----------------------------------------------------------------------

-------------------------테이블에 txt 값 넣기 --------------------------

SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%'; 

SET NAMES 'utf8';
 SET character_set_client = charset_name;
 SET character_set_results = charset_name;
 SET character_set_connection = charset_name;

 

load data local infile 'D:\\zipcode.csv' 
into table zipcode
character set euckr fields terminated by ',';

-----------------------------------------------------------------------------------