If it were me, I'd create a new table in the database with enough columns
to handle all the data in the file. Then I'd do insert . . . . select
into the table that need the data.
Hope this helps,
Michael Ridinger
On Thu, 22 Mar 2001, Daniel Newman wrote:
> 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
>
>
---------------------------------------------------------------------
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
