Hi Monty,
First of all, thanks so much for responding to my question! I am using
MySQLworkbench 5.2.37CE. I'm pretty sure the issue has to do with
something on the administrator side of things. We managed to get it so that
I can click the icon to export the file, but he's still working on getting
Hi!
> "Fred" == Fred G writes:
Fred> Thanks Dhaval. Putting the join condition before INTO outfile doesn't
seem
Fred> to work, either.
Fred> When I try to use the same outfile name 'test123.csv' I get Error Code:
Fred> 1086 File 'test123.csv' already exists. But then when I try to find
Thanks!
On Thu, Jul 26, 2012 at 12:05 AM, wrote:
> 2012/07/26 06:52 +0530, Dhaval Jaiswal
> SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
> ENCLOSED BY '"' LINES TERMINATED BY '\n'
>
> as above give your join condition before INTO OUTFILE.
>
> Right
2012/07/26 06:52 +0530, Dhaval Jaiswal
SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n'
as above give your join condition before INTO OUTFILE.
Right: MySQL server writes into some directory where it is, not where
Thanks Dhaval. Putting the join condition before INTO outfile doesn't seem
to work, either.
When I try to use the same outfile name 'test123.csv' I get Error Code:
1086 File 'test123.csv' already exists. But then when I try to find the
csv file on my computer, there is a folder with that name, b
SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n'
as above give your join condition before INTO OUTFILE.
On Thu, Jul 26, 2012 at 1:32 AM, Fred G wrote:
> Hi--
>
> I'm trying to do the following:
> SELECT db.emp.emp_fname, db.emp.
Hi--
I'm trying to do the following:
SELECT db.emp.emp_fname, db.emp.emp_fname, db.sale.sale_date,
db.sale.sale_no, db.sale.sale_total_amt
into outfile 'test123.csv'
FIELDS terminated by ','
FROM db.emp
LEFT OUTER JOIN db.sale
ON db.sale.emp_id = db.emp.emp_id;
The query without exporting the fil
