In the last episode (Nov 17), John Kopanas said:
> I have a text file with over 500K rows of data in it. The problem is
> that the data is no seperated by commas but instead occupy a certain
> amount of characters. So for instance:
>
> ID 1 -11
> NAME 12-50
> COMPANY_NAME 51-100
> ...
>
> How would you parse import this data into mysql?
Create a table that matches your layout exactly, then
LOAD DATA ...
FIELDS TERMINATED BY ''
FIELDS ENCLOSED BY '';
It's mentioned in one of the comments at
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
--
Dan Nelson
dnelson@stripped
