Example for loading data generated by TPC-H.

loaddata.sql

USE tpch;

LOAD DATA LOCAL INFILE '/home/joyeecheung/tpch_2_16_1/dbgen/region.tbl' INTO TABLE REGION
FIELDS TERMINATED BY '|' LINES TERMINATED BY '|\n';

LOAD DATA LOCAL INFILE '/home/joyeecheung/tpch_2_16_1/dbgen/nation.tbl' INTO TABLE NATION
FIELDS TERMINATED BY '|' LINES TERMINATED BY '|\n';

LOAD DATA LOCAL INFILE '/home/joyeecheung/tpch_2_16_1/dbgen/supplier.tbl' INTO TABLE SUPPLIER
FIELDS TERMINATED BY '|' LINES TERMINATED BY '|\n';

LOAD DATA LOCAL INFILE '/home/joyeecheung/tpch_2_16_1/dbgen/customer.tbl' INTO TABLE CUSTOMER
FIELDS TERMINATED BY '|' LINES TERMINATED BY '|\n';

LOAD DATA LOCAL INFILE '/home/joyeecheung/tpch_2_16_1/dbgen/part.tbl' INTO TABLE PART
FIELDS TERMINATED BY '|' LINES TERMINATED BY '|\n';

LOAD DATA LOCAL INFILE '/home/joyeecheung/tpch_2_16_1/dbgen/partsupp.tbl' INTO TABLE PARTSUPP
FIELDS TERMINATED BY '|' LINES TERMINATED BY '|\n';

LOAD DATA LOCAL INFILE '/home/joyeecheung/tpch_2_16_1/dbgen/orders.tbl' INTO TABLE ORDERS
FIELDS TERMINATED BY '|' LINES TERMINATED BY '|\n';

LOAD DATA LOCAL INFILE '/home/joyeecheung/tpch_2_16_1/dbgen/lineitem.tbl' INTO TABLE LINEITEM
FIELDS TERMINATED BY '|' LINES TERMINATED BY '|\n';