Hi Bruce,
SELECT ... INTO OUTFILE always creates the file local to the database server.
If you want to dump results where your perl script is running you'll have to
use another method such as receiving the results of the query normally and
writing the file in the perl script.
Regards,
Thanks all who replied.
After I posted I kept looking and found it... Also had folks point it
out to me.
Your suggestion is what I ended up doing.
Bruce
Gavin Towey wrote:
Hi Bruce,
SELECT … INTO OUTFILE always creates the file local to the database
server. If you want to dump
I have a bit of perl code that ends with an error:
$sql=SELECT convert_tz( a.stamp,'GMT','$tz' ) as ts, a.status,
a.reason, a.tl
INTO OUTFILE '/application/result.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '\'
LINES TERMINATED BY '\n'
FROM alerts a
Jay Blanchard [EMAIL PROTECTED] wrote:
[snip]
Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't create/write to file
'C:\data_out\day234\data_out.txt' (Errcode: 2)
[EMAIL PROTECTED] egor]$ perror 2
System error: 2 = No such
[snip]
Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't create/write to file
'C:\data_out\day234\data_out.txt' (Errcode: 2)
So I copy the query statement and send via PhpMyAdmin, it ended up as
below
#1 - Can't create/write to
-
From: Jay Blanchard [EMAIL PROTECTED]
To: Mysql General (E-mail) [EMAIL PROTECTED]
Sent: Thursday, October 21, 2004 10:35 PM
Subject: RE: SELECT... INTO OUTFILE problem
[snip]
Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't
... INTO OUTFILE problem
[snip]
Exception occured in Microsoft OLE DB Provider for ODBC Drivers,
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20a-nt]Can't create/write to file
'C:\data_out\day234\data_out.txt' (Errcode: 2)
So I copy the query statement and send via PhpMyAdmin, it ended up as
below
#1 - Can't create
into outfile problem
On Mon, Apr 09, 2001 at 03:48:43PM +0200, Niklas Rudemo wrote:
I'm trying to select into outfile to a file that already exist.
This has been discussed before, I know, but the solution suggested
results in an SQL-error, as shown below. So what's the real solution?
Select your rows
To: Niklas Rudemo
Cc: [EMAIL PROTECTED]
Subject: Re: select into outfile problem
On Mon, Apr 09, 2001 at 03:48:43PM +0200, Niklas Rudemo wrote:
I'm trying to select into outfile to a file that already exist.
This has been discussed before, I know, but the solution suggested
results in an SQL
On Mon, Apr 09, 2001 at 03:48:43PM +0200, Niklas Rudemo wrote:
I'm trying to select into outfile to a file that already exist.
This has been discussed before, I know, but the solution suggested
results in an SQL-error, as shown below. So what's the real solution?
Select your rows into a
10 matches
Mail list logo