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