MySQL Data Loading

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:

• http://dev.mysql.com/doc/refman/5.1/en/load-data.html.