query결과 file 저장 샘플

SELECT seq,pack,trans_no,collect_date,trans_date_pos,status,order_cs,trans_who INTO OUTFILE '/tmp/out1.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
FROM orders where trans_date_pos > '2007-9-4 00-00-00' and trans_date_pos<'2007-9-6 23:59:59' ;