MySQL Data Loading
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: