LOAD

Instead of inserting the data one by one into the table through INSERT statement, the user can also directly upload batch of data with LOAD statement.

The general syntax for LOAD statement is:

LOAD DATA INFILE file_name INTO TABLE table_name [IGNORE num LINES]

If ABC company staff already prepared csv files for Product, Customer and sales, he can load the data into the table he just created with following commands:

LOAD DATA INFILE Product.csv INTO TABLE Product

LOAD DATA INFILE Customer.csv INTO TABLE Customer

LOAD DATA INFILE sales.csv INTO TABLE sales

The IGNORE num LINES option can be used to skip lines at the beginning of the file. For example, you can use IGNORE 1 LINES to skip the header if sales.csv includes one line of header:

LOAD DATA INFILE sales.csv INTO TABLE sales IGNORE 1 LINES