Shawn,
Thanks a lot for this explanation. It works perfectly.
Best,
Adam
[EMAIL PROTECTED] wrote:
While reading http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
I found this passage
"
If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty
(''), a fixed-row (non-delimited) format
Hi,
I have a text file with fixed-width columns that I'd like to get loaded
into a table. Against Oracle the script would be as follow:
LOAD DATA INFILE 'myfile.data' append INTO TABLE MYTABLE (
FIELD1 POSITION(1:10),
FIELD2 POSITION(11:20),
FIELD3 POSITION(21:21),
FIELD4 POSITION(22:40)
)
Is th
