Done:
1) Solved the problem which I got yesterday. Thanks to Darcy and Dylan.
2) Create two tables: blocks and location. Due to the oversized integer of startIpNum and endIpNum in blocks, I used DECIMAL(10,0) as their data type instead of INTEGER.
3) Load csv files into database. Need to delete all double-quote from the original files, then load into database. (Thanks to Darcy)
Need to test all cities in Nova Scotia tomorrow.
No comments:
Post a Comment