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 N
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 N
