mysql导出select结果到文件_MySQL

bitsCN.com
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 &＃39;xxx.txt&＃39;; 例如： mysql -h127.0.0.1 -uroot -p000000 select * from a into outfile &＃39;1.txt&＃39;; 两种方法效果一样的 第二种方式的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 &＃39;/t&＃39; lines terminated by &＃39;/r/n&＃39; 第一种方法和第二种方法的结合：使用 mysql -e执行导出到文件的sql语句 mysql -hxx -uxx -pxx -e "query statement" db 例如: mysql -h127.0.0.1 -uroot -p000000 -e"select * from a into outfile &＃39;1.txt&＃39; fields terminated by &＃39;,&＃39; lines terminated by &＃39;/r/n&＃39;" test 如果不想输出列名信息： mysql -h127.0.0.1 -uroot -p000000 -N -e"select * from a into outfile &＃39;1.txt&＃39; fields terminated by &＃39;,&＃39; lines terminated by &＃39;/r/n&＃39;" test 默认情况下， mysql -e导出的文件，列是用"/t"分隔，行是用"/r/n"分隔(dos)，行是用"/n"分隔(unix 追加一种方式： select col002,col005,col004,col008 into outfile &＃39;e:/mysql/i0812.txt&＃39; fields terminated by &＃39;|&＃39; lines terminated by &＃39;/r/n&＃39; from a where col003 in (select col001 from qdbm) order by col005;
作者 zhanghe086 bitsCN.com