( MySQL ) 쿼리문 csv export (내보내기)

---

/home 디렉토리에 test.csv 로 내보내기 

(해당 디렉토리는 mysql linux user 의 Write 권한이 필요함)

SELECT * 

INTO OUTFILE '/home/test.csv' 

FIELDS TERMINATED BY ',' 

OPTIONALLY ENCLOSED BY '"' 

LINES TERMINATED BY '\n' 

FROM [TBL_NAME]

---