I'm very new to mysql and I can't find any information about this on the internet... can someone who's an expert please tell me whether you think it's impossible to load a .txt file into a mysql table using similar syntax to this:
LOAD DATA LOCAL INFILE '/path/test2.txt' INTO TABLE test FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\r\n';
This works perfectly for a single-space delimited data file, or if a comma is between the quotes, for a comma-delimited data file. Is there any way at all to tell mysql to look for multiple spaces?