List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 17 2006 11:26pm
Subject:Re: Importing Text File Into mySQL
View as plain text  
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
Thread
Importing Text File Into mySQLJohn Kopanas18 Nov
  • Re: Importing Text File Into mySQLBruce Ferrell18 Nov
  • Re: Importing Text File Into mySQLDan Nelson18 Nov
    • Re: Re: Importing Text File Into mySQLJohn Kopanas18 Nov
      • Re: Importing Text File Into mySQLDan Nelson18 Nov
  • Re: Importing Text File Into mySQLVisolve DB Team18 Nov