LOAD DATA INFILE using Perl - Leigh Sharpe - com.mysql.lists.win32

4 messages in com.mysql.lists.win32LOAD DATA INFILE using Perl

From	Sent On	Attachments
Leigh Sharpe	02 Dec 2003 16:51
Petr Vileta	03 Dec 2003 04:45
Leigh Sharpe	03 Dec 2003 14:18
Petr Vileta	03 Dec 2003 14:50

Subject:	LOAD DATA INFILE using Perl
From:	Leigh Sharpe (lsha...@pacificwireless.com.au)
Date:	12/02/2003 04:51:56 PM
List:	com.mysql.lists.win32

Hi all,

I'm writing a Perl script which uses the LOAD DATA LOCAL INFILE command to
dump a large amount of data to a database. The problem is, I'm generating the
data within the script itself, then writing it to disk, then reading it back
with the LOAD DATA command. Is there any way (within the perl script) of piping
it straight from memory, rather than going via disk?

Regards, Leigh