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
hi all...
i have a strange problem with a simple script that is doing select into
outfile...
the thing just does that. it does a select into an outfile. if i print
the query that's passed to mysql_result in the script and then copy it
and paste it z`into the mysql client it works fine
harms [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 5:06 AM
To: 'mysql'
Subject: select ... into outfile=stdout ?
hi list,
i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and
would like
to send the output to stdout to further processing.
unfortunately
-
From: walter harms [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 5:06 AM
To: 'mysql'
Subject: select ... into outfile=stdout ?
hi list,
i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and would
like
to send the output to stdout to further processing
for LOAD DATA INFILE. See Section 12.2.6, LOAD DATA
INFILE Syntax.
By default, its output to stdout.
Give it a try !!!
-Original Message-
From: walter harms [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 5:06 AM
To: 'mysql'
Subject: select ... into outfile=stdout ?
hi
hi list,
i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and would
like
to send the output to stdout to further processing.
unfortunately i found no proper way to force the output to stdout. for now i use
the redirection of the mysql -NB output but the interface lacks the
meaning as the
corresponding clauses for LOAD DATA INFILE. See Section 12.2.6, LOAD DATA
INFILE Syntax.
By default, its output to stdout.
Give it a try !!!
-Original Message-
From: walter harms [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 5:06 AM
To: 'mysql'
Subject: select
Hi all,
I want to export the values based on the condition. I export them as csv.
select * into outfile 'filename.csv' from table;
the problem is one field in table has many lines, means with \n. I couldn't
import the values into the xls sheet.
any ideas how to escape the new line characters
new lines using select * into outfile
Hi all,
I want to export the values based on the condition. I export them as
csv.
select * into outfile 'filename.csv' from table;
the problem is one field in table has many lines, means with \n. I
couldn't import the values into the xls sheet.
any ideas
Try using:
select * into outfile 'filename.csv' fields enclosed by '' terminated by
',' lines terminated by '\n' from table
Regards,
Velen
- Original Message -
From: Saravanan [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Tuesday, May 13, 2008 9:26 PM
Subject: how to escape
* into outfile
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Date: Wednesday, May 14, 2008, 1:35 AM
Try using:
select * into outfile 'filename.csv' fields
enclosed by '' terminated by
',' lines terminated by '\n' from table
Regards,
Velen
- Original Message -
From
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still get Errcode: 13. I
Mike Spreitzer wrote:
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still
'
(Errcode: 13) when executing 'SELECT INTO OUTFILE'
[EMAIL PROTECTED] /]# ls -ld /dump1
drwxrwxrwx 2 mysql mysql 4096 Feb 22 19:11 /dump1
[EMAIL PROTECTED] /]# ls -l /dump1
total 16
-rw-r--r-- 1 mysql mysql 29 Feb 22 18:38 foo.bar
-rw-r--r-- 1 root root 742 Feb 22 19:11 red1_p2.sql
[EMAIL
what happens when you delete the files that are already in there? Looks
like you're dumping to a file owned by root.
Jed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to file '/dump1/red1_p2.txt'
(Errcode: 13) when executing 'SELECT INTO OUTFILE'
[EMAIL PROTECTED] /]# ls -l dump1
total 8
-rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql
[EMAIL PROTECTED] /]# ps axlw | grep mysqld
0 0 8494 1 25 0 3408 944 wait Spts/5 0:00 /bin/sh
/usr
:
mysqldump: Got error: 1: Can't create/write
to file '/dump1/red1_p2.txt' (Errcode: 13) when executing 'SELECT INTO
OUTFILE'
I'm reading thru http://dev.mysql.com/doc/refman/5.0/en/select.html and it says
that it will not write to an already existing file (so you deleted the old files
I'm unable to select into an outfile, the path is in an nfs mount point. I'm
sure it's some sort of permissions issue or something, but I can't figure it
out. I've googled everything I can think of and haven't found anything. Any
help or suggestions would be greatly appreciated.
The error I'm
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 11:51 AM
To: mysql@lists.mysql.com
Subject: Select into outfile on nfs mount point
I'm unable to select into an outfile, the path is in an nfs
mount point. I'm
sure it's some sort of permissions issue or something, but I
can't figure it
out
]
[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 commandline
, 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 on nfs mount point
I'm unable to select into an outfile
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
directory level, it has to be writeable
Hi,
I have a database where the database character set is utf-8 and some rows
are ascii.
I want to save the results of some queries, and SELECT ... INTO OUTFILE
looks like an easy way to do it. But I need the output in ucs-2. Is there
any way to specify the charset for SELECT ... INTO OUTFILE
, 2006 2:23 PM
Subject: Charset for SELECT ... INTO OUTFILE
Hi,
I have a database where the database character set is utf-8 and some rows
are ascii.
I want to save the results of some queries, and SELECT ... INTO OUTFILE
looks like an easy way to do it. But I need the output in ucs-2
Hi
Iam having a problem using select into outfile command, iam getting
the following error. can anyone help me trace the problem.
mysql SELECT * INTO OUTFILE'/home/public1/data.txt' FROM temp_table
WHERE last_time_update = 2006-04-01;
ERROR 1 (HY000): Can't create/write to file
'/home/public1
From: Mohammed Abdul Azeem Sent: 13 April 2006 07:29
Hi
Iam having a problem using select into outfile command, iam getting
the following error. can anyone help me trace the problem.
mysql SELECT * INTO OUTFILE'/home/public1/data.txt' FROM temp_table
WHERE last_time_update = 2006-04-01
Subject: Re: how to suppress NULL values in SELECT ... INTO OUTFILE ?
At 13:29 +0100 4/1/06, C.R.Vegelin wrote:
Hi everyone,
I am struggling to make a CSV file, with rows like: 1;2;;4;;2;9
where NULL values are suppressed in the CSV file.
I tried the following alternatives:
a) Select
without NULLs or quotes.
Regards, Cor
- Original Message -
From: Jorrit Kronjee [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Sunday, April 02, 2006 11:33 AM
Subject: Re: how to suppress NULL values in SELECT ... INTO OUTFILE ?
Cor,
You can set the enclosing character
Hi everyone,
I am struggling to make a CSV file, with rows like: 1;2;;4;;2;9
where NULL values are suppressed in the CSV file.
I tried the following alternatives:
a) Select ... Into Outfile ... Fields Terminated By ';' Escaped By ''
Lines Terminated By '\r\n' ...
but this generates
At 13:29 +0100 4/1/06, C.R.Vegelin wrote:
Hi everyone,
I am struggling to make a CSV file, with rows like: 1;2;;4;;2;9
where NULL values are suppressed in the CSV file.
I tried the following alternatives:
a) Select ... Into Outfile ... Fields Terminated By ';' Escaped By ''
Lines Terminated
-
From: Paul DuBois [EMAIL PROTECTED]
To: C.R.Vegelin [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Saturday, April 01, 2006 6:11 PM
Subject: Re: how to suppress NULL values in SELECT ... INTO OUTFILE ?
At 13:29 +0100 4/1/06, C.R.Vegelin wrote:
Hi everyone,
I am struggling to make a CSV file
I'm using mysql 3.23.58 on linux. I recently upgraded from RedHat 9 to Fedora
3 and now I am unable to write to an outfile.
If I have started mysql with the simple mysql I get 'access denied' even if
I am trying to put it into my home directory.
mysql select lname,fname,mname,addr,city,stzip
You have to enable the file_permission for the user in order to create file.
On 3/3/06, Bruce Bales [EMAIL PROTECTED] wrote:
I'm using mysql 3.23.58 on linux. I recently upgraded from RedHat 9 to Fedora
3 and now I am unable to write to an outfile.
If I have started mysql with the simple
Hi,
I am going to implement a mysql hosting, and I would to make a question,
if a mysql-user with only a SELECT privilege make this query:
SELECT * FROM table1 INTO OUTFILE '/mysqldb/data/test.sql';
the result is a file in this path with the content of the table.
I could think that a malicious
with the content of the table.
I could think that a malicious user can do several querys like this and fill
my disk.
How could I secure this command ?
According to mysql manual
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the
selected rows to a file. The file is created
in this path with the content of the table.
I could think that a malicious user can do several querys like this and fill
my disk.
How could I secure this command ?
From the manual:
http://dev.mysql.com/doc/mysql/en/select.html
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the
selected
Hi listers
I once asked if there is an SQL syntax permitting to copy a row in the
same table. I got no answer, so there is no such syntax.
now i meant to have found a work-around using (see subject).
problem is, that when i do a SELECT * ... INTO OUTFILE .. i will also
catch the PRIMARY KEY
}
If your PRIMARY KEY is an auto_increment field, just omit foo_ID from
the columns list in both the INSERT and SELECT.
-Original Message-
From: suomi [mailto:[EMAIL PROTECTED]
Sent: Friday, August 19, 2005 7:08 AM
To: mysql@lists.mysql.com
Subject: SELECT ... INTO OUTFILE ... and LOAD DATA
no answer, so there is no such syntax.
now i meant to have found a work-around using (see subject).
problem is, that when i do a SELECT * ... INTO OUTFILE .. i will also
catch the PRIMARY KEY column if there is one and the LOAD DATA INFILE
... of this file will fail because of duplicate keys. i
Thomas Spahni wrote:
Hi suomi,
it can be done with a temporary table. See the following example.
Regards,
Thomas Spahni
snip
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
Greetings from Austin, TX:
What is the proper syntax for SELECT INTO OUTFILE
in a statement with a UNION keyword, like the following:
SELECT Addresses FROM editors
UNION
SELECT Addresses FROM authors
Thanks,
Lynn Bender
UnsubCentral
Secure Email List
Please, MySQL doesn´t understands the following special escape sequence: ' \s' ?
I want spaces in the export.
How to do?
Greetings.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
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?
--
David L. Van Brunt, Ph.D.
Outlier Consulting Development
mailto
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
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 with SELECT ... INTO OUTFILE.
--
David L. Van Brunt, Ph.D.
Outlier Consulting Development
mailto
. The following rows will be the data.
Those are tabs between the columns.
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 have a good SELECT
into OUTFILE
query that gives me what I want... Except
/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 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
It seems that each time we select into an OUTFILE that already exists
(re-use a name) the server crashes.
Anyone have any ideas if this is a setting or just a bug?
Thanks.
Chris.
Chris Fossenier [EMAIL PROTECTED] wrote:
It seems that each time we select into an OUTFILE that already exists
(re-use a name) the server crashes.
Anyone have any ideas if this is a setting or just a bug?
It's known bug:
http://bugs.mysql.com/bug.php?id=2123
--
For technical
Thompson, Jordan [EMAIL PROTECTED] wrote:
I wan to use a variable for the outfile file name in a select into clause. I am
doing something like:
set @fileName=/tmp/result.text
SELECT col1, col2 INTO OUTFILE @fileName
FIELDS TERMINATED BY ','
FROM test_table;
the interpreter dies at the
I wan to use a variable for the outfile file name in a select into clause. I am
doing something like:
set @fileName=/tmp/result.text
SELECT col1, col2 INTO OUTFILE @fileName
FIELDS TERMINATED BY ','
FROM test_table;
the interpreter dies at the @fileName...
if I exchange @filename with
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
hello my friends.. i have some problem :
1. when i drop data out into a file, sometimes i have some problem like the file can't
be opened(when i save into .xls or .mdb or other) how can i solve this problem?
2. how can i use mysql with delphi?please give me more explanation about it.. and must
subsequent executions do not. This is because of query caching.
If the SELECT Statement is changed to:
Select * SQL_NO_CACHE
INTO OUTFILE YourFileName
FIELDS TERMINATED BY ',' ENCLOSED BY ''
From AnyTable
subsequent executions do not. This is because of query caching.
If the SELECT Statement is changed to:
Select * SQL_NO_CACHE
INTO OUTFILE YourFileName
FIELDS TERMINATED BY ',' ENCLOSED BY ''
From AnyTable
Hello,
I've read documentation and looked in the list archives but
haven't found anything that specifically addresses the idea
of writing out fields in a fixed-field format.
I'd like to do something like SELECT id,date INTO OUTFILE
'data.txt' id = column 1, date = column 10; to get a file
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 written partially indeed, but not including all records
matching the query.
Help would
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 written partially indeed, but not including all records
matching the query.
Help would
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 written
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 partially
Hello!
I have one subroutine in Perl (DBI) that prepares and executes SELECT-like
queries and fetches the output from them.
When I submit SELECT * INTO OUTFILE query, then $sth-fetchrow_array()
generates Error:
Error 19 (fetch() without execute())
How to avoid it?
How can this subroutine
: select * into outfile
Hello!
I have one subroutine in Perl (DBI) that prepares and executes SELECT-like
queries and fetches the output from them.
When I submit SELECT * INTO OUTFILE query, then $sth-fetchrow_array()
generates Error:
Error 19 (fetch() without execute())
How to avoid it?
How
Yes, I can do that, but the subroutine is the same that execute other
SELECT-like statements. It does:
prepare
execute
fetch result
print
Then it must understand when SELECT * INTO OUTFILE must be executed and do
not try to fetch data.
Is there any criteria that say that there is no data to fetch
Hi,
I'm trying to do the following:
select * into outfile '/tmp/data.txt' fields terminated by';' from customer
Although the mysql-user has all privileges (except the grant priv) on the database
and the file_priv in the user table I get an 'Access denied for user..' when
executing the select
Hello.
On Fri, May 31, 2002 at 02:08:57AM +0100, [EMAIL PROTECTED] wrote:
[...]
BP So you may consider upgrading and check if you find the problems
BP still reproducable.
[...]
I generally only update on a needs basis, most notably for security,
as I like to keep things stable and
Hi,
I have a user for doing a select-to-outfile, and I've granted both the
file privilege and also (just for the table in question) the select
privilege to that user.
Trying it at the command-line gives me Access denied... which seems
like it can't be the case having granted the correct
Hi,
I have a user for doing a select-to-outfile, and I've granted both the
file privilege and also (just for the table in question) the select
privilege to that user.
Trying it at the command-line gives me Access denied... which seems
like it can't be the case having granted the correct
mysql-readers,
Thursday, May 30, 2002, 10:38:14 AM, you wrote:
mr I have a user for doing a select-to-outfile, and I've granted both the
mr file privilege and also (just for the table in question) the select
mr privilege to that user.
mr Trying it at the command-line gives me Access denied
So, why do I keep getting the following? What does it mean? Has my
mail been delivered to the mailing list or not?
This is a forwarded message
From: Mailer-Daemon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Thursday, May 30, 2002, 11:20:03 AM
===8==Original message
Egor,
EE Yeah, Access denied error means that user doesn't have necessary
EE permissions. Can you provide some more info? i.e. full error
EE message, how did you set up file_priv using GRANT statement or
EE updated privilege tables manually? What version MySQL client and
EE server do you use?
I
mysql-readers,
Thursday, May 30, 2002, 1:31:50 PM, you wrote:
EE Yeah, Access denied error means that user doesn't have necessary
EE permissions. Can you provide some more info? i.e. full error
EE message, how did you set up file_priv using GRANT statement or
EE updated privilege tables
not reliably update in all cases. Not all
combinations of GRANT / REVOKE completely without sometimes
needing a flush privileges, even in a single (root) session.
(b) [MAIN ISSUE]
One might expect a statement such as the following type of
statement: SELECT fields INTO OUTFILE /tmp/j FROM
when they are
evaluated again? See http://www.mysql.com/doc/P/r/Privilege_changes.html.
(b) [MAIN ISSUE]
One might expect a statement such as the following type of
statement: SELECT fields INTO OUTFILE /tmp/j FROM tbl; to
require the FILE privilege (global) and the SELECT privilege
Benjamin,
In response to your mail of Friday, May 31, 2002 1:24:17 AM:
BP Hello.
Thanks for the feedback.
BP 3.23.36 is a bit outdated by now
Sure -- actually that's why I was vague about the side-issue (below)
and why I checked the changelogs for an explicit fix to my main
problem.
BP
Hi,
i am using mysql 4.0.0 version -alpha in windows 2000.
i'd like to export the mysql table data to excel format.
So,i use the outfile method.
mysqlselect * into outfile 'backup.xls' from tablename;
When i open 'backup.xls' in microsoft excel,i can view all the data ,but i
can't view the field
Hello
Is there a way to include table column names as headers using 'SELECT * INTO
OUTFILE...'?
Cheers
James A Robertson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
On Mon, Nov 19, 2001 at 03:19:41PM +1300, James Robertson - Composite Design wrote:
Hello
Is there a way to include table column names as headers using 'SELECT * INTO
OUTFILE...'?
Cheers
James A Robertson
No. SELECT selects data from the table. The column names are not table
data
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
86 matches
Mail list logo
