Most Recent Comments

2019-01-19 18:43:34   


SQL Query for Wards/Postcodes Taking Too Long

Okay, I found out, something when I was trying to update a table (to c...

2018-02-10 14:03:13   


Calling OpenSchema Method To Find Out Database Name



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.


No comments.

Your Name:
Your Comment:

6 minus 4 is: