select .. into outfile

나중에 명령어 다시 치기 귀찮아서… ^^;

SELECT subject,content into outfile ‘/home/aa/aa.csv’ fields terminated by ‘,’ enclosed by ‘”‘ escaped by ‘\’ lines terminated by ‘
‘ FROM `ch_d_1` WHERE content like ‘%급여%’ or content like ‘%수당%’;

댓글 남기기

이메일은 공개되지 않습니다. 필수 입력창은 * 로 표시되어 있습니다