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
I believe the master.info and relay-log.info are only on the slaves and are
specific to each slave (as each slave could be at a different point in the
bin-log.)
Thanks,
Carl
On Jul 25, 2012, at 2:22 PM, Richard Reina wrote:
> I am trying to setup a new slave server and when I go to the master
I am trying to setup a new slave server and when I go to the master to
copy over master master.info and relay-log.info they seem to be
missing? Not in /var/lib/mysql and could not find it with #: find /
-name master.info
The master server has been setup for years and already has three
slaves repli
Yes, the rows are in primary key order, however each row contains
specific integer primary keys; I'm not inserting nulls into a table
where the primary key is auto increment, so I don't see why concurrent
inserts would fight for similar spots (although, I'm admittedly not a
MySQL hotshot, so the ba
I'm skeptical that use-treads can every be very effective.
What order are the rows in? They are probably in PRIMARY KEY order, which
means that the INSERTing threads will be fighting over similar spots in the
table.
Is it I/O bound when it is single-threaded? If so, then there can't be any
i
