This function is great! Anyone know how to include the column names, table
info, any extra miscellaneous info? I use SQLyog for exporting to csv and they
do include the columns, my bet is its some SQL option. The manual doesn't
specify, at least in the select syntax part.
Ariel
-Mensaje
[snip]
This function is great! Anyone know how to include the column names, table
info, any extra miscellaneous info? I use SQLyog for exporting to csv and they
do include the columns, my bet is its some SQL option. The manual doesn't
specify, at least in the select syntax part.
[/snip]
Any
... But I though there was a -include_column_names
option or something :)
Which way should I go?
Ariel
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 01 de marzo de 2006 10:58
Para: Ariel Sánchez Mora; mysql@lists.mysql.com
Asunto: RE: file permission
On Tuesday 28 February 2006 22:55, unplug wrote:
Hi,
When I use a query SELECT * into outfile '/tmp/report.csv' fields
terminated by ',' lines terminated by '\n' FROM table;, it will
create a file with the following permission and owner.
-rw-rw-rw- 1 mysql mysql 2489 Mar 1 11:30
Thanks!
But I want to change the default setting of the file permission and
ownership. (i.e. the file will be created with permission and
ownerhsip according to my setting).
On 3/1/06, CodeHeads [EMAIL PROTECTED] wrote:
On Tuesday 28 February 2006 22:55, unplug wrote:
Hi,
When I use a query
You can't do that. The mysql server runs as user mysql, so it cannot create
files owned by another user. If you run the mysql server as root (don't!),
you might be able to do that, but I do not believe mysql has a facility for
changing the owner of a file. You are better off running a script
On Tuesday 28 February 2006 23:41, Joshua Kugler wrote:
You can't do that. The mysql server runs as user mysql, so it cannot
create files owned by another user. If you run the mysql server as root
(don't!), you might be able to do that, but I do not believe mysql has a
facility for changing
Actually, here is my case.
There is a script owned by user A running daily.
script---
rm -rf /tmp/report.csv
mysql -umysql -pabc table -e SELECT * into outfile '/tmp/report.csv'
fields terminated by ',' lines terminated by '\n' FROM table;
In the first run, a file with the following
Since you don't show your grant statement, it is difficult tell you what
the problem is.
Since FILE is a global permission you need to grant it on *.* not
somedatabase.*
David Scott wrote:
Greetings all
I am not able to GRANT file permission to users. All permissions end
up being issued with
Thank you Gerald.
That was the problem. I thought I read that FILE permission could not
be set to a specific table so I was using somedatabase.*.
David Scott
On Monday, August 4, 2003, at 11:42 AM, gerald_clark wrote:
Since you don't show your grant statement, it is difficult tell
At 11:13 PM -0400 5/8/01, A. Chris Nichols wrote:
Hello everyone,
I was wondering if anyone could help me out and explain a bit about
the FILE permissions and how they relate to two particular scenarios:
In both cases MySQL is running on SunOS 5.7 and running MySQL client
version 3.22.23b
11 matches
Mail list logo