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