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
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
Maybe you can use mysql -e instead.
On Mon, Oct 20, 2008 at 12:51 AM, walter harms <[EMAIL PROTECTED]> wrote:
> hi ronaldo i tried and failed.
> it seems that mysql has no option to specify a select statement.
> did i mis something ?
>
> re,
> wh
>
>
> walter harms schrieb:
> > hi ronaldo,
> > i
hi ronaldo i tried and failed.
it seems that mysql has no option to specify a select statement.
did i mis something ?
re,
wh
walter harms schrieb:
> hi ronaldo,
> iadmit i was mysql (the command) fixated :)
>
> thx a lot,
> wh
>
> Rolando Edwards schrieb:
>> Try mysqldump !!!
>>
>> On this w
hi ronaldo,
iadmit i was mysql (the command) fixated :)
thx a lot,
wh
Rolando Edwards schrieb:
> Try mysqldump !!!
>
> On this web page, http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
>
> It says the following:
>
> --fields-terminated-by=..., --fields-enclosed-by=...,
> --fields-optio
Try mysqldump !!!
On this web page, http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
It says the following:
--fields-terminated-by=..., --fields-enclosed-by=...,
--fields-optionally-enclosed-by=..., --fields-escaped-by=...
These options are used with the -T option and have the same meani
ginal Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 12:06 PM
To: 'David Ruggles'; mysql@lists.mysql.com
Subject: RE: Select into outfile on nfs mount point
Can you "touch" the file name? It might be a permission issue at the
dire
, March 26, 2007 12:37 PM
To: David Ruggles
Subject: RE: Select into outfile on nfs mount point
>>> Date: Monday, March 26, 2007 11:50:59 AM -0400
>>> From: David Ruggles <[EMAIL PROTECTED]>
>>> To: mysql@lists.mysql.com
>>> Subject: Select into outfile
ECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 12:01 PM
To: David Ruggles
Subject: Re: Select into outfile on nfs mount point
the file on the mount point has to be able to be created, and
read/write by the user that is invoking the mysql call. e.g., if this
is begin done at the comman
Can you "touch" the file name? It might be a permission issue at the
directory level, it has to be writeable.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: David Ruggles [ma
Thomas Spahni wrote:
Hi suomi,
it can be done with a temporary table. See the following example.
Regards,
Thomas Spahni
CREATE TEMPORARY TABLE duptemp SELECT * FROM duprows WHERE id = 2;
ALTER TABLE duptemp CHANGE id id INT NULL;
UPDATE duptemp SET id = NULL;
INSERT INTO duprows SELECT * F
Hi suomi,
it can be done with a temporary table. See the following example.
Regards,
Thomas Spahni
USE test;
CREATE TABLE duprows (
id INT NULL AUTO_INCREMENT PRIMARY KEY,
content VARCHAR(255)
) TYPE=MyISAM;
INSERT INTO duprows VALUES(NULL, 'some text'),(NULL, 'some other text
If you want to have all values except the primary key be the same and
say your is foo_ID
You can simply do
INSERT INTO foo
(foo_ID... {rest of columns list})
SELECT new primary key value,
{rest of columns list}
FROM foo
WHERE foo_ID = {primary key value of row you want to copy}
If
"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
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...
-
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
[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
FABULOUS! It works like a charm, even on a very complex series of commands.
Redirected output into a file, and viola!
Thanks a bunch!
On 4/6/04 22:17, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 22:04 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
>> Okay, so I didn't miss anything... Good to
At 22:04 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
Okay, so I didn't miss anything... Good to know! Any way I CAN create an
output file with those names? Maybe if I make a table first?
One way, if tab-delimited output is satisfactory, is to just run
mysql in batch mode.
In interactive mode, yo
Okay, so I didn't miss anything... Good to know! Any way I CAN create an
output file with those names? Maybe if I make a table first?
On 4/6/04 21:43, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 20:43 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
>> I've scoured the online documentation, and I
At 20:43 -0500 4/6/04, David L. Van Brunt, Ph.D. wrote:
I've scoured the online documentation, and I have a good SELECT into OUTFILE
query that gives me what I want... Except that there is no 1st row with
column names.
Hoping I missed something obvious... Any pointers on this one?
You can't do it w
MySQL won't write data to a file if the file already exists.
Make sure you've deleted the old file or given MySQL a new
filename to write to.
Jan
--
Janice Wright
Ingenta plc
[EMAIL PROTECTED]
http://www.ingentaselect.com/
Sometime recently Rahmat Hidayat said:
> hello my friends.. i have so
Rahmat> 2. how can i use mysql with delphi?please give me more explanation about it..
and must i have some application for it?
Goto google and find "TmySQL delphi component". You will get the
examples there too.
Ivan
--
Andreas,
Thursday, September 12, 2002, 3:56:58 PM, you wrote:
AM> After a query
AM> SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
AM> ENCLOSED BY '"' FROM testtable
AM> the following error occurs:
AM> Error writing file 'test.csv' (Errcode: 28)
AM> The file was written pa
perror 28
Error code 28: No space left on device
Andreas Metzner wrote:
>Hi All,
>
>After a query
>SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
>ENCLOSED BY '"' FROM testtable
>
>the following error occurs:
>Error writing file 'test.csv' (Errcode: 28)
>
>The file was w
?
thanks.
Ioannis Livassov
- Original Message -
From: "Tom Gao" <[EMAIL PROTECTED]>
To: "edatanew.com" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, September 08, 2002 6:50 PM
Subject: Re: select * into outfile
> you need to execute your
you need to execute your query first
you can avoid execute by using the just 'do' or else you'll need to execute
your query before getting results
Tom
- Original Message -
From: "edatanew.com" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 09, 2002 12:35 AM
Subject:
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
28 matches
Mail list logo
