MySQL Data Loading

From PeformIQ Upgrade
Jump to navigation Jump to search

Inserting large amounts of data into MySQL with LOAD DATA INFILE

Use this on the command line withing the MySQL client to build load data:

load data infile 'customers.csv' into table site.customer
fields terminated by ',' enclosed by '"' lines terminated by '\n'
(email,password,title,first_name,last_name);

The field separator is specified as the default separator is a tab.

For more info on the command see: