Upgrading Open Codepoint Database
Okay, just a quick reminder for myself when I am doing it next time: this is the right way of doing it:for F in *.csv ; do mysql -e "LOAD DATA INFILE '"`pwd`/$F$"' INTO TABLE tablename201805 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\\r\\n' " databasename ; done
As I have just done it with May 2018 version and I want to do it again once the August 2018 version is released. At the place where I work they are telling us to use a new postcode and I am just suspicious. Are they retiring our current postcode? Very weird.
Comments
No comments.