Hi folks,
Using the ever-handy phpMyAdmin tool for MySQL db management, there's a CSV
import option to parse lines like this (all GUI-like):
LOAD DATA INFILE 'file.csv'
INTO TABLE tbl_name
FIELDS TERMINATED BY ','
FIELDS ENCLOSED BY '\',
FIELDS ESCAPED BY '\'
LINES TERMINATED BY 'auto'
You might want to try LINES TERMINATED BY '\r\n' or LINES TERMINATED
BY '\n'. I am not familiar with the auto option.
Thanks,
Cary
On Mon, Nov 14, 2011 at 8:19 AM, Ken Irwin kir...@wittenberg.edu wrote:
Hi folks,
Using the ever-handy phpMyAdmin tool for MySQL db management, there's a CSV