Hi Kim AFAIK, LOAD DATA INFILE will only work off a file. So you would have to create a temp file. Another option is to create a multiple value insert query e.g.
INSERT INTO arb_table (arb_column_1...arb_column_n) VALUES (arb_value_1..arb_value_n), (arb_value_1..arb_value_n), ......... Although LOAD DATA INFILE is, i think, the fastest way to get data into MySQL, if you first have to create a temp file, the additional nuisance and time factors might make the above query a valid alternative. Regards Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) ----- Original Message ----- From: "Kim Kohen" <[EMAIL PROTECTED]> To: "PHP" <[EMAIL PROTECTED]> Sent: Tuesday, October 21, 2003 6:24 AM Subject: [PHP-DB] Load MySQL from a variable > G'day all, > > I have some data from Filemaker Pro which needs to have a lot of > search/replacing done before importing into MySQL. I have used ereg_replace > in PHP and end up with a variable holding the correct data. (there are > several hundred rows of data in the variable) > > Is it possible to use Load data infile with a variable or will I need to > write out a temp file and then load that? > > Cheers and thanks > > kim > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
