Re: Skip columns from tab-del.txt on LOAD DATA INFILE?

[Paul DuBois]

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