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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
