了解知识
mysql -hxx -uxx -pxx -e "query statement" db > file
例如:
mysql -h127.0.0.1 -uroot -p000000 -e"select * from a" test > 1.txt
        host ip     user   password   query statement  database  filename
这样会输出列名信息,如果不想输出列名信息:
 
mysql -h127.0.0.1 -uroot -p000000 -N -e"select * from a" test > 1.txt
        host ip     user   password   query statement  database  filename
mysql -hxxx -uxx -pxx
select * from table into outfile 'xxx.txt';
例如:
mysql -h127.0.0.1 -uroot -p000000
select * from a into outfile '1.txt';
 
两种方法效果一样的
 
第二种方式的mysql文档:
SELECT [select options go here] INTO {OUTFILE | DUMPFILE} filename 
EXPORT_OPTIONS 
FROM table_references [additional select options go here]
 
例如:
mysql -h127.0.0.1 -uroot -p000000
select * from a into outfile "1.txt" fields terminated by '\t' lines terminated by '\r\n'
 
第一种方法和第二种方法的结合:使用 mysql -e执行导出到文件的sql语句
mysql -hxx -uxx -pxx -e "query statement" db
例如:
mysql -h127.0.0.1 -uroot -p000000 -e"select * from a into outfile '1.txt' fields terminated by ',' lines terminated by '\r\n'" test
 
如果不想输出列名信息:
mysql -h127.0.0.1 -uroot -p000000 -N -e"select * from a into outfile '1.txt' fields terminated by ',' lines terminated by '\r\n'" test
 
默认情况下, mysql -e导出的文件,列是用"\t"分隔,行是用"\r\n"分隔(dos),行是用"\n"分隔(unix)
标签: MySQL
扩展知识