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 -
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