List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:July 31 1999 4:14pm
Subject:Re: Convert to MySQL
View as plain text  
At 2:10 PM +0200 7/31/99, Bo Stark wrote:
>Is there ANY way to convert an textfile like:
>
>XXX | ZZZ | XXX
>YYY | XYZ | XZZ
>
>..to an MySQL database?


Sure.  Run it through a Perl script that strips out the junk and
converts it to tabs, then use LOAD DATA to read the resulting file
into a table.

-- 
Paul DuBois, paul@stripped
Thread
Convert to MySQLBo Stark31 Jul
  • Re: Convert to MySQLPaul DuBois31 Jul
  • Convert to MySQLJani Tolonen1 Aug
  • RE: Convert to MySQLsteven holloway3 Aug