Re: Select Into OUTFILE problem

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 dum

RE: Select Into OUTFILE problem

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

Select Into OUTFILE problem

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

Re: SELECT... INTO OUTFILE problem

"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

RE: SELECT... INTO OUTFILE problem

As Jay said, it's either a permission issue or the file already exists. MySQL will not overwrite a file that already exists. -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, October 21, 2004 3:35 PM To: Mysql General (E-mail) Subject: RE: SELECT...

Re: SELECT... INTO OUTFILE problem

- 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][ODB

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

SELECT... INTO OUTFILE problem

Hi, I am sending a query to a MySQL server on a network via LabView EXEC QUERY VI. It looks like that SELECT `data1` , `data2` INTO OUTFILE 'C:\\data_out\\day234\\data_out.txt' FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' FROM data_table; What I

Re: FW: select into outfile problem

gt; Sent: den 9 april 2001 17:01 > 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

FW: select into outfile problem

Maybe I didn't state the problem clearly enough. I want write to a file that does exist, i.e., overwrite the existing file. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: den 9 april 2001 17:01 To: Niklas Rudemo Cc: [EMAIL PROTECTED] Subject: Re: select

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-error, as shown below. So what's the real solution? Select your rows into a tem

select into outfile problem

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? Niklas Rudemo Virtutech mysql> select * into outfile 'person.txt' from person; Query OK, 0 rows