Here is the code I'm using...
LOAD DATA LOCAL INFILE '/Path/to/File' INTO TABLE working_load FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r'
What is the proper way to handle a file that will have some fields enclosed by a character, but not all? Or, is there a way I can get Excel to enclose all fields with quotes?
Thanks in advance,