I have a flat file that I am trying to load to a MySQL database (fixed-length fields).
When I try: LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable It is generating a ton of errors, but the end result is that it's populating only the first field for all records and all subsequent fields are NULL Any suggestions? Tried these too: LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable lines terminated by '\n\' LOAD DATA '/mypath/flatfile.txt' INTO TABLE mytable lines terminated by '\r\n\' No go :-( Thanks! Rw
