Tuesday, September 28, 2010

Create tables and load data into database

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