mysql 쿼리 결과 파일 저장

참고 사이트 : http://stackoverflow.com/questions/356578/how-to-output-mysql-query-results-in-csv-format

1 2 3 4 5 6

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