Mysql Save MySQL query results into a text or CSV file

SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.txt'

or

SELECT order_id,product_name,qty
FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

Import CSV file directly into MySQL

load data local infile 'uniq.csv' into table tblUniq
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(uniqName, uniqCity, uniqComments)