Brad Stockdale writes:
> Hello all,
>
> I'm new to the list... Been using MySQL for various things for a year
> now, but have never ran into the following situation...
>
> I have a flat text file that I have exported from FileMaker Pro. I want
> to import that into MySQL, but there's a catch... There are two tables I am
> trying to load, and some of the columns need to go into each...
>
> Is there a way to do this with a single LOAD DATA INFILE statement? The
> reason I want to do it all at once and not in multiple files is because I
> have auto_increment columns in each for a primary key. I want to make sure
> the two tables key columns dont get out of sync with each other.
>
> Is there a way to load multiple tables with a single LOAD DATA statement?
>
> Thanks,
> Brad
>
No, but there is a workaround. Create a temporary table that would get
all of the data. Then do INSERT from SELECT for each of the two tables
and then drop a temporary table.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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