Queries below shows how to import data from a CSV file to a new table....

CREATE TABLE 
      auspost(Pcode INT(10),
              Locality VARCHAR(100),
              State VARCHAR(10),
              Comments VARCHAR(100),
              DeliveryOffice VARCHAR(100),
              PresortIndicator INT(10),
              ParcelZone VARCHAR(10),
              BSPnumber INT(10),
              BSPname VARCHAR(100),
              Category VARCHAR(100)
            );

...then

LOAD DATA LOCAL INFILE 'pc-full_20100224.csv' 
INTO TABLE auspost 
    FIELDS TERMINATED BY ',' 
    LINES TERMINATED BY '\n';