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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php