MESSAGE
| DATE | 2003-04-08 |
| FROM | Joe Villari
|
| SUBJECT | Subject: [hangout] Output file MYSQL
|
I'm trying to get some data out of a mysql table into a file. I was able
to run the command below and it appears that a file named
shares_merged.cvs was created. I can't find it anywhere. I ran updatedb
and still get no luck using locate.
mysql> SELECT * INTO OUTFILE 'shares_merged.cvs'
-> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
-> FROM ray_merged;
Query OK, 970 rows affected (0.02 sec)
Tried writing one to my home directory but it looks like I can't write
there from mysql.
mysql> SELECT * INTO OUTFILE '/home/joev/shares_merged.cvs'
-> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
-> FROM ray_merged;
ERROR 1: Can't create/write to file '/home/joev/shares_merged.cvs'
(Errcode: 13)
How do I get this data into a file?
Joe
____________________________
NYLXS: New Yorker Free Software Users Scene
Fair Use -
because it's either fair use or useless....
NYLXS is a trademark of NYLXS, Inc
|
|
