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