i. Create 'ipisp' table mysql> CREATE TABLE IPISP ( ipFROM DOUBLE NOT NULL, ipTO DOUBLE NOT NULL, countrySHORT VARCHAR(2) NOT NULL, countryLONG VARCHAR(64) NOT NULL, ipISP VARCHAR(255) NOT NULL, PRIMARY KEY(ipFROM, ipTO) ); --------------------------------------------------------------- ii.Import the 'IPISP.csv' database into table 'ipisp' mysql> LOAD DATA INFILE "/IPISP.csv" INTO TABLE ipisp FIELDS TERMINATED BY ',' ENCLOSED BY '"';