I've been looking into the help files provided for this command, and
couldn't see a reference to the thing I'm wanting to do (so I've assumed it
can't be done). BUT, just wanted confirmation in case there's a way to do
this:
I'm expecting to get a CSV file soon that I need to import into my mySQL
database. Trouble is, the CSV file includes lots of columns that I don't
need, and some that I need in separate tables. I saw in the TODO list that
you will be offering the ability to choose which columns get included, but
can you do a join function on the LOAD DATA INFILE?
If not, would the only option be to generate new files (using FSO on NT)
that are stripped down versions of the source file specific to each table?
And then, to do the LOAD DATA multiple times with the new files?
Hope this isn't the only option, as I don't want to have to script that as
well!
Thanks for your help,
Daniel Newman.
Bis-Web Ltd.
Tel: 01993 880614
Fax: 01993 881625
****************************************************************************
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer.
****************************************************************************
---------------------------------------------------------------------
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
