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

2001-09-06 Thread Anthony E.
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? ie -

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

2001-09-06 Thread 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