importing a csv into the db

[eluser]ray73864[/eluser]
the fields don't have to match field for field, the 'id' field for instance could be field #1 in the DB but field #10 in the CSV file.

what you are doing when naming them is the 'load data infile' goes through and looks for the column in the csv file that you have named with the same name as the field in the DB.

eg:

csv file: 1,"Ray","Australia","blah",123456789
db table: id, name, phone, country

where "blah" is a dummy field that isn't in your database.

in the 'load data infile' you would do:

Code:

LOAD DATA INFILE my.csv REPLACE INTO TABLE contact FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\\n' (id, name, country, @dummy, phone)

This would pull out every row in the csv file and stick the correct information into the correct columns.