G'day CPT John W. Holmes and Rory
>> 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.
> Agree that LOAD DATA INFILE will probably still be faster overall, even with
> the file write. Tr
From: "Rory McKinley" <[EMAIL PROTECTED]>
> 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), (a
From: "Kim Kohen" <[EMAIL PROTECTED]>
> 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 vari
ds 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
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 d
