Tuesday, May 15, 2007

How do I import delimited data into MySQL?

How do I import delimited data into MySQL?

LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3);



www.svdeals.com super value deals

No comments: