MySQL Import CSV data tutorial guide
It's actually fairly straight forward:
load data local infile 'billpayments-payments.csv' into table payments
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
The above assumes that your fields are terminated by a comma (some programs like OpenOffice change this to a semi-colon ;) and that they are enclosed with "
The above will insert the data from billpayments-payments.csv into the table payments.
Tags:
mysql, import, csv, tutorial, guideit, infile, billpayments, payments, fields, terminated, enclosed, quot, assumes, comma, programs, openoffice, semi, colon, insert,