Cacher is the code snippet organizer for pro developers

select * from test_info   
into outfile '/tmp/test.csv'   
fields terminated by ',' optionally enclosed by '"' escaped by '"'   
lines terminated by '\r\n';   
只导出数据


echo SELECT * from animal | mysql -udavemysql -p***** testdb > mysqloutfile.txt

只导出数据结构：
SELECT * INTO OUTFILE '/var/lib/mysql-files/MemberSt.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'Member'

csv 导入：
load data infile '/tmp/test.csv'   
into table test_info    
fields terminated by ','  optionally enclosed by '"' escaped by '"'   
lines terminated by '\r\n'
IGNORE 1 ROWS; //忽略第一行表头