CSV export

mysql 2014. 9. 2. 05:33

[select 결과를 CSV 파일로 export]

select 원하는 필드1, 원하는 필드2, ... into outfile "/tmp/export.csv" fields terminated by ',' optionally enclosed by '"' lines terminated by "\n" from 테이블명 where 조건;

Posted by scentless
,