$ wget http://www.post.japanpost.jp/zipcode/dl/kogaki/zip/ken_all.zip
$ unzip ken_all.zip
$ nkf -w --overwrite KEN_ALL.CSV
$ nkf -g KEN_ALL.CSV
UTF-8 (CR)
$ cp ./KEN_ALL.CSV /var/lib/mysql-files/
$ mysql -h container-mysql -uroot -p
mysql> CREATE DATABASE japanpost CHARACTER SET utf8;
mysql> use japanpost;
mysql> CREATE TABLE zipcode (
publicCode char(5) NOT NULL,
oldCode char(5) NOT NULL,
code char(7) NOT NULL,
prefectureKana varchar(10),
cityKana varchar(100),
townKana varchar(100),
prefecture varchar(10),
city varchar(200),
town varchar(200),
flgMultiCode tinyint(1),
flgKoazaBanchi tinyint(1),
flgChome tinyint(1),
flgMultiTown tinyint(1),
updateState tinyint(1),
updateReason tinyint(1),
PRIMARY KEY (code)
);
mysql> LOAD DATA LOCAL INFILE '/var/lib/mysql-files/KEN_ALL.CSV' IGNORE INTO TABLE zipcode FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"';
mysql> select count(code) from zipcode;
+-------------+
| count(code) |
+-------------+
| 119958 |
+-------------+
1 row in set (0.02 sec)
以上 That's all.