List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 6 2001 10:56pm
Subject:Re: Skip columns from tab-del.txt on LOAD DATA INFILE?
View as plain text  
At 3:45 PM -0700 9/6/01, Anthony E. wrote:
>I have a tabdelimited file with 10 cols, and want to
>only import 5 of them with LOAD DATA INFILE.
>
>I know how to define which cols go where in the mysql
>table, but this assumes i want to import every column
>from the tabdelimited file.
>
>How do I ignore certain cols from the import file?

Preprocess the file to create a temporary file containing only
the columns of interest.



-- 
Paul DuBois, paul@stripped
Thread
Skip columns from tab-del.txt on LOAD DATA INFILE?Anthony E.7 Sep
  • Re: Skip columns from tab-del.txt on LOAD DATA INFILE?Paul DuBois7 Sep