List:General Discussion« Previous MessageNext Message »
From:John Kopanas Date:November 17 2006 11:05pm
Subject:Importing Text File Into mySQL
View as plain text  
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?

Thanks for your help :-).

-- 
John Kopanas
john@stripped

http://www.kopanas.com
http://www.cusec.net
http://www.soen.info
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