LEGES"
why in the world did i post the link to the answer
last friday if people are too lazy to read
GRANT FILE ON *.* TO 'asdfsdf'@'localhost';
is a global setting because you access *the hosts FILESYSTEM* with it
http://lmgtfy.com/?q=mysql+permissions+into+outfile
http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied-but-my-user-has-all-access-and-the-fold
signature.asc
Description: OpenPGP digital signature
On 9/19/2014 10:59 AM, Don Wieland wrote:
On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:
the target folder don't matter
that is clearly a *MySQL error* that your *MYSQL user* lack the needed
permissions
Yes i figured that - so the question is, how do I give full permissions to that
user?
room_id
> JOIN tl_users u on u.user_id = apt.user_id
>
> WHERE
>
> apt.time_start between '1388552400' and '1420088399'
> and r.location_id = '1'
>
> GROUP BY u.user_id, c.client_id
> having count(*) > 1
>
> ORDER BY u.first_nam
Maybe you need to grant access from localhost to the user?
On Fri, September 19, 2014 16:59, Don Wieland wrote:
> On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:
>
>> the target folder don't matter
>> that is clearly a *MySQL error* that your *MYSQL user* lack the needed
>> permissions
>
> Yes i
On Sep 19, 2014, at 9:11 AM, Christophe wrote:
> Don't you have root access to MySQL instance ?
I guess not, I am using a managed server VPSLatch. I chatted with them and they
are going to GRANT the permissions I need…at least that is what the tech said.
I waiting with baited breath ;oP
Thanks
Le 19/09/2014 18:00, Christophe a écrit :
Hi there,
Le 19/09/2014 17:19, Don Wieland a écrit :
grant all privileges
on teal1dwd_teal.*
to 'teal1dwd_teal'@'localhost'
identified by 'my_user_pw';
I get this error:
#1044 - Access denied for user 'teal1dwd'@'localhost' to database
'teal
Hi there,
Le 19/09/2014 17:19, Don Wieland a écrit :
grant all privileges
on teal1dwd_teal.*
to 'teal1dwd_teal'@'localhost'
identified by 'my_user_pw';
I get this error:
#1044 - Access denied for user 'teal1dwd'@'localhost' to database
'teal1dwd_teal'
I think you are trying to ac
@'localhost' to database
'teal1dwd_teal'
Do I need to perform this query in a different place? Sigh…
Don
On Sep 19, 2014, at 8:03 AM, Reindl Harald wrote:
> "into outfile" is *not* a db-specific permission
>
> http://lmgtfy.com/?q=mysql+permissions+into
the question is, how do I give full permissions to
> that user?
>
> I did go to my cPanel and delete the user and recreated the user adding them
> to the DB with ALL PRIVILEGES.
> Obviously this is not enough.
"into outfile" is *not* a db-specific permission
http://lmgtfy.co
On Sep 19, 2014, at 7:50 AM, Reindl Harald wrote:
> the target folder don't matter
> that is clearly a *MySQL error* that your *MYSQL user* lack the needed
> permissions
Yes i figured that - so the question is, how do I give full permissions to that
user?
I did go to my cPanel and delete the u
room_id = apt.room_id
> JOIN tl_users u on u.user_id = apt.user_id
>
> WHERE
>
> apt.time_start between '1388552400' and '1420088399'
> and r.location_id = '1'
>
> GROUP BY u.user_id, c.client_id
> having count(*) > 1
>
> ORDER BY u.fi
oom_id = apt.room_id
JOIN tl_users u on u.user_id = apt.user_id
WHERE
apt.time_start between '1388552400' and '1420088399'
and r.location_id = '1'
GROUP BY u.user_id, c.client_id
having count(*) > 1
ORDER BY u.first_name, u.last_name, c.last_name, c.fi
I don't know what you mean by "straight" mysql connection. At any rate,
the idea is to use --quick or otherwise using a connection which uses
mysql_use_result over mysql_store_result.
http://dev.mysql.com/doc/refman/5.6/en/mysql.html
Best,
/ Carsten
On 19-02-2014 12:02, Machiel Richards wrot
- Original Message -
> From: "Machiel Richards"
> Subject: Re: Mysql into outfile problem
>
> I have checked now and there is nothing in the Slow logs.
It may be turned off, then. Depending on your version you can change the
settings without having to restart th
I have checked now and there is nothing in the Slow logs.
On 19/02/2014 15:33, Johan De Meersman wrote:
- Original Message -
From: "Machiel Richards"
Subject: Mysql into outfile problem
- when we run an explain on the query it shows that it is
using index
- Original Message -
> From: "Machiel Richards"
> Subject: Mysql into outfile problem
>
> - when we run an explain on the query it shows that it is
> using indexes and the amount of rows it accesses is about 165000 rows
> out of a 90mil+ rows t
Hi,
the queries are done by connecting to the database using mysql
workbench or otherwise after ssh to server by using straight mysql
connection.
regards
On 19/02/2014 12:51, Carsten Pedersen wrote:
If you're doing this from the cmd-line client, try running it using
--quick. th
Best,
If you're doing this from the cmd-line client, try running it using --quick.
Best,
/ Carsten
On 19-02-2014 09:03, Machiel Richards wrote:
Hi guys
I am hoping that someone might have experienced this before or
might know why we are getting this.
We regularly need to run some quer
Hi guys
I am hoping that someone might have experienced this before or
might know why we are getting this.
We regularly need to run some queries and export the results to a
csv file.
However we seem to be experiencing the following issues:
- when we run an exp
s missing software)
>
> select last_logon.host_name_short
> from last_logon
> left join mcafee on last_logon.host_name_short = last_logon.host_name_short
> where mcafee.host_name_short is null
> and last_logon.host_name_short like 'w%'
> -- the above works
> into out
By using your shell's variable substitution, I'm afraid.
export outfile='/path/to/file'
mysql -e "select blah into outfile '$outfile'"
You'll have to build a shell script or something that generates your filename,
and then do an interactive ca
lt;<<
Look up the command! http://dev.mysql.com/doc/refman/5.5/en/select.html
Aside from PREPARE, the OUTFILE-name does not automate.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
mcafee on last_logon.host_name_short = last_logon.host_name_short
where mcafee.host_name_short is null
and last_logon.host_name_short like 'w%'
-- the above works
into outfile (select
concat('Missing-',date_format(now(),'%Y%m%d%H%i'),'txt');
-- this line break
2011/09/03 03:40 +0800, Dennis
But it seems that there is no "select ... into LOCAL file" statement. Any
suggestion is appreciated.
Indeed: you can use only standard output.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Thanks, Tyler,Â
That's very helpful.
Dennis
--- On Sat, 9/3/11, Tyler Poland wrote:
From: Tyler Poland
Subject: Re: select ... into local outfile ... ???
To: mysql@lists.mysql.com
Date: Saturday, September 3, 2011, 3:45 AM
Dennis,
The following closely simulates the default "IN
Dennis,
The following closely simulates the default "INTO OUTFILE", you'll have
to modify it slightly for your purposes:
mysql --delimiter=comma -N < select_statement.sql \
| sed 's/\"/\\\"/g' \
| sed 's/\t/\",\"/g' \
| sed &
hi, there,
the following is my sql statement:
SELECTÂ Â HIGH_PRIORITYÂ Â SQL_BIG_RESULTÂ Â SQL_NO_CACHE
 tb.url_sign, m_url,   m_title,  m_weight   INTO OUTFILE  '/tmp/a.csv'Â
FIELDS TERMINATED BY ',' Â ENCLOSED BY '\"'Â Â LINES Â TERMINATED BY '\n' STARTING
BY '='
FROM d_lo
Hi all,
>From the manual:
*Any file created by INTO OUTFILE or INTO DUMPFILE is writable by all users
on the server host. The reason for this is that the MySQL server cannot
create a file that is owned by anyone other than the user under whose
account it is running. (You should never run
mys
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
> serve
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.
Re
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 '\&qu
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 fin
e same 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-
> &
>
>> -Original Message-----
>> 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 (exspec
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 list,
> i need some options
x27;
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 i found no proper way to force the output to stdout. for now i use
the redirection of the &q
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
pe new lines using select * 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
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
>Subject: how to escape 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, m
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
:
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
te 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/
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]
ed1_p2.txt'
(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
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
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
ca
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you. It's working now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ok, on my linux (slackware 10) /var/www is owner by root.root with
permissions rwxr-xr-x (755). Say you want mysql to put your data
in a subdirectory under /var/www named data.
As root, do:
mkdir /var/www/data
chgrp mysql /var/www/data
chmod 775 /var/www/data
Now mysql has write permissions to /
I experimented with a local /var/www folder. I assumed setting 2, 6, or
7 for the Other value would give mysql write privileges, but mysql would
not settle for anything less than a 7 in that last slot. What was really
curious to me was that the User and Group settings were inconsequential.
I even s
ctory to some other folder?
>
>> --
>> From:Gerald L. Clark
>> Sent:Friday, April 27, 2007 10:09 AM
>> To: Kebbel, John
>> Cc: mysql@lists.mysql.com
>> Subject: Re: Permissions and Into Outfile
>>
>> Kebbel, John wrote:
>> >
Kebbel, John wrote:
cat /etc/passwd on my Macintosh 10.3 at work (I'm using Linux at home) shows me
this for mysql ...
mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false
The home directory for mysql is /var/empty, which does exist. Should I write
~into file~ output to this folder or should
mysql home directory
to some other folder?
> --
> From: Gerald L. Clark
> Sent: Friday, April 27, 2007 10:09 AM
> To: Kebbel, John
> Cc: mysql@lists.mysql.com
> Subject: Re: Permissions and Into Outfile
>
> Kebbel, John wrote:
> > I
sketball, 9SDrama, 9SDriverEd1, 9SDriverEd2, 9SRecreation, 9STeamSports1,
9STeamSports2, 9SWeights
into outfile '/tmp/srhs9.txt'
from sched_students, SCHED_COURSES where (sched_students.id = SCHED_COURSES.id)
and (grade = 8) order by lastname, firstname;
The user 'mysql'
sketball, 9SDrama, 9SDriverEd1, 9SDriverEd2, 9SRecreation, 9STeamSports1,
9STeamSports2, 9SWeights
into outfile '/tmp/srhs9.txt'
from sched_students, SCHED_COURSES where (sched_students.id = SCHED_COURSES.id)
and (grade = 8) order by lastname, firstname;
--
MyS
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
m: David Ruggles [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 s
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 great
SELECT header.date_in,header.pid,header.status,body.body_data
into outfile '/tmp/mysql/117070515226878'
from header,body
where header.date_in='1170705152'
and body.date_in=header.date_in and header.pid='26878'
and body.pid=header.pid
;
- Original Message -
Hello list:
Need some help with the following query:
mysql> SELECT header.date_in,header.pid,header.status,body.body_data from
header,body where header.date_in='1170705152' and
body.date_in=header.date_in and header.pid='26878' and body.pid=header.pid
into outfile '/t
er 09, 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 n
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
Hi Johan,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql > outfile.txt
"outfile.txt" it looks something like:
"OrderID", "Quant", "OrdrDate", "code1", "code2"...
10021, 12, 20060412, 23, 95...
10022, 5, 20060412, , 75...
But, I
ething like:
"OrderID", "Quant", "OrdrDate", "code1", "code2"...
10021, 12, 20060412, 23, 95...
10022, 5, 20060412, , 75...
But, I never get a complete file. I get a out of memory error after a
hour or 2!!
If I instead insert the following code in qu
Hi George,
To do it incrementally is not really an option, since i have to run it
as a script during a short time-frame every night, and theres simply not
time to process the files.
The outfile is about 2 - 10 Gb every time.
The tables have about 100 - 180 columns, and to do a COALESCE
al Message-
From: Johan Lundqvist [mailto:[EMAIL PROTECTED]
Sent: Monday, May 08, 2006 10:16 AM
To: mysql@lists.mysql.com
Subject: Outfile syntax and out of memory
Hi,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql
after a
hour or 2!!
If I instead insert the following code in queryfile.sql:
"INTO OUTFILE 'outfile.txt'"
Now my outfile.txt don't get the first row with the column names, and
any NULL values are exported as "\N".
This is a big problem, cause the import
12, 20060412, 23, 95...
10022, 5, 20060412, , 75...
But, I never get a complete file. I get a out of memory error after a
hour or 2!!
If I instead insert the following code in queryfile.sql:
"INTO OUTFILE 'outfile.txt'"
Now my outfile.txt don't get the first row with
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&#x
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):
Thanks Jorrit,
Yes, it is a combi of Paul's suggestion to use IFNULL()
with the ENCLOSED BY '' option. So when using:
Select IFNULL(Jan,''), IFNULL(Feb,''), ... Into Outfile ...
Fields Terminated By ';' Enclosed By '' Escaped By ''
;[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>;
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, with rows like:
o extend the FIELDS options to enable this ...
Regards, Cor
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "C.R.Vegelin" <[EMAIL PROTECTED]>;
Sent: Saturday, April 01, 2006 6:11 PM
Subject: Re: how to suppress NULL values in SELECT ... IN
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 ''
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&#x
EMAIL PROTECTED]> wrote:
> > >
> > > > Hi Ariel,
> > > >
> > > > Maybe this example helps you to create CSV output from MySQL.
> > > > The first SELECT generates the headerline; the second the data.
> > > > ( SELECT 'Fi
is example helps you to create CSV output from MySQL.
> > > The first SELECT generates the headerline; the second the data.
> > > ( SELECT 'FieldA','FieldB','FieldC', ... )
> > > UNION
> > > ( SELECT `FieldA`, `FieldB`, `FieldC`, ...
>
data.
> > ( SELECT 'FieldA','FieldB','FieldC', ... )
> > UNION
> > ( SELECT `FieldA`, `FieldB`, `FieldC`, ...
> > INTO OUTFILE 'D:/MySQL Datafiles/myFile.csv'
> > FIELDS TERMINATED BY ','
> > LINES TERMINATED BY
.. )
> UNION
> ( SELECT `FieldA`, `FieldB`, `FieldC`, ...
> INTO OUTFILE 'D:/MySQL Datafiles/myFile.csv'
> FIELDS TERMINATED BY ','
> LINES TERMINATED BY '\r\n'
> FROM ... ...
> GROUP BY `FieldA`, `FieldB`, `FieldC`, ...
> );
>
> Don't forget the
Hi Ariel,
Maybe this example helps you to create CSV output from MySQL.
The first SELECT generates the headerline; the second the data.
( SELECT 'FieldA','FieldB','FieldC', ... )
UNION
( SELECT `FieldA`, `FieldB`, `FieldC`, ...
INTO OUTFILE 'D:/MySQL Datafile
, 2006 5:12 PM
To: mysql@lists.mysql.com
Subject: 'Into outfile' doesn't include the column names. How can it be
done?
When using select into outfile, I can only get the table data, but I can't
find how to include the column names. I haven't been able to include the
column names in
At 14:12 -0600 3/6/06, Ariel Sánchez Mora wrote:
When using select into outfile, I can only get
the table data, but I can't find how to include
the column names. I haven't been able to include
the column names into the actual return of the
query, and they don't get stored in th
Ariel Sánchez Mora <[EMAIL PROTECTED]> wrote on 03/06/2006 03:12:20 PM:
> When using select into outfile, I can only get the table data, but I
> can't find how to include the column names. I haven't been able to
> include the column names into the actual return of the
When using select into outfile, I can only get the table data, but I can't find
how to include the column names. I haven't been able to include the column
names into the actual return of the query, and they don't get stored in the .csv
Anyone know how to include the column na
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
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
If say something like the following from the mysql command line tool:
SELECT * FROM dognames INTO OUTFILE 'C:/outfiles/dognames.tab';
How do I get mysql to include the column names in the file's output?
Ferindo
--
MySQL General Mailing List
For list archives: http://lists.mys
On Wed, 2005-08-24 at 10:11 -0300, Alejandro Gad wrote:
> 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/tes
Wednesday, August 24, 2005, 5:11:14 PM, you wrote:
> 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';
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.
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
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 column if there is one and the LOAD DATA INFILE
>
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
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
[snip]
Sometimes I need to execute 'select * into outfile '/tmp/t1.out'
more than 1 times before I get the right result. But once mysql succeeds
in writing t1.out, it does not overwrite it if the same sql command is
executed for the 2nd time unless t1.out is removed. Is
Hi, mysql Gurus,
Sometimes I need to execute 'select * into outfile '/tmp/t1.out'
more than 1 times before I get the right result. But once mysql succeeds
in writing t1.out, it does not overwrite it if the same sql command is
executed for the 2nd time unless t1.out is re
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
1 - 100 of 210 matches
Mail list logo
