Thank You.***
-Original Message-
From: Mark Matthews [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 11:05 AM
To: Jeff McKeon
Cc: Mysql List
Subject: Re: CSV Formated output
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff McKeon wrote:
> Ok, I've got FILE priv se
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff McKeon wrote:
> Ok, I've got FILE priv set on my user now, it had to use
>
> GRANT FILE ON *.*
>
> As it appears the FILE prive isn't a db level priv?
>
> Still getting the same results though, can't write the file...
>
> ERROR 1 at line 1: Can't
You do not have access to either that file or that directory. Try to adjust
permissions then rerun.
-Original Message-
From: Jeff McKeon [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 9:50 AM
To: Mysql List
Subject: RE: CSV Formated output
Ok, I've got FILE priv set on my
sage,
and any copy of it, from your computer system. Thank You.***
-Original Message-
From: Jeff McKeon
Sent: Thursday, July 03, 2003 10:32 AM
To: Mysql List
Subject: RE: CSV Formated output
Yes, I used the proper name for "username" on the GRANT command..
It was actually
m
*
-Original Message-
From: Jeff McKeon
Sent: Thursday, July 03, 2003 10:25 AM
To: Mysql List
Subject: RE: CSV Formated output
Ok, so SELECT INTO OUTFILE and TERMINATED BY will work except for one
thing
They require GRANT FILE access for the user to work and I can't seem to
add t
ender and delete the original message,
and any copy of it, from your computer system. Thank You.***
-----Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 9:25 AM
To: Mysql List
Subject: RE: CSV Formated output
Jeff,
By "manual", I mean
t,
Andy
> -Original Message-
> From: Jeff McKeon [mailto:[EMAIL PROTECTED]
> Sent: 03 July 2003 13:50
> To: Andy Eastham; Mysql List
> Subject: RE: CSV Formated output
>
>
> Thanks Andy, that will do!
>
> I don't have a manual, using the open source MySQL
[snip]
I don't have a manual, using the open source MySQL. I do have a book
(New Riders "MySQL") but was looking for "deliminated" not "terminated."
Found it now. Thanks again for the help.
[/snip]
You can always use the online manual.
HTH
--
MySQL General Mailing List
For list archives: http:
nk You.***
-Original Message-
From: Andy Eastham [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 8:06 AM
To: Mysql List
Subject: RE: CSV Formated output
Jeff,
Use SELECT INTO OUTFILE and FIELDS TERMINATED BY ','
See the manual for more info.
Andy
> -Original
Don't forget ouput with spaces/tabs/quotes etc...
The more adventurous solution
use perl
use DBI
use DBD:CSV(or Text::CSV_XS)
use DBD:mysql
then just take the output of the select and insert into the CSV
Matthew
On Thu, 3 Jul 2003, Jeff McKeon wrote:
> Is there a way to output the
hi jeff:
what i do - have been doing for year is dump the data you want using the
dump proceedure in mysql - then use a simple shell script to convert it to
csv - i.e.
cat mysql.dump.file |
while read line
do
field1=`echo "$line" | cut -f1`
field2=`echo "$line" | cut -f2`
field???=`echo "$
Jeff,
Use SELECT INTO OUTFILE and FIELDS TERMINATED BY ','
See the manual for more info.
Andy
> -Original Message-
> From: Jeff McKeon [mailto:[EMAIL PROTECTED]
> Sent: 03 July 2003 12:38
> To: [EMAIL PROTECTED]
> Subject: CSV Formated output
>
>
Is there a way to output the results of a select query into a CSV or
Comma Deliminated format?
Thanks,
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in this communication is confidential. It
is intended only for the sole
13 matches
Mail list logo
