mysql 특정 테이블 csv 파일로 저장

select * from 테이블 into outfile '테이블명.csv' fields terminated by ',';

ex: ) select * from ex_table into outfile 'ex_table.csv' fields terminated by ',';

저장경로 : /usr/local/mysql-5.6.10-osx10.7-x86_64/data/test/ex_table.csv

 

 

#####################################################################

 

 

T stock  code.csv 작업

 

mysql 접속

use sise;

select * from code order by name into outfile 'code.csv' fields terminated by ',';

 

# root 로 접속

cd /u02/util/mysql-5.1.51-solaris10-i386/data/sise

 

ftp atserver1p

 

binary

put code.csv