Re: How to import a file in to mysql table

[Tyler Longren]

LOAD DATA LOCAL INFILE 'filename.txt' INTO TABLE `table` FIELDS TERMINATED BY '|' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n';

That typically works for me. I dunno as I usually terminate my fields with ";" as opposed to |.

tyler

http://longren.no-ip.org/