Re: Load MySQL from a variable
| From: | CPT John W. Holmes | Date: | Tue, 21 Oct 2003 11:39:07 +0000 |
| Subject: | Re: Load MySQL from a variable | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31218@lists.php.net to get a copy of this message | ||
From: "Kim Kohen" <kim@webguide.com.au>
> 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?
The temp file would probably be the best/fastest way to do it.
---John Holmes...