SELECT * FROM rank INTO OUTFILE '/home/a.txt';
文件生成在 MySQL 服務器主機上,需 FILE 權限。
mysql -uroot -proot -P3306 -h10.35.13.89 dbname -e "SELECT * FROM rank" > /home/a.txt
適用於遠程服務器,結果經標準輸出重定向保存到本地。
mysql> TEE /home/a.txt
mysql> SELECT * FROM rank;
mysql> EXIT
-- 或
mysql> \T output.txt
mysql> \t -- 關閉
會將後續所有輸出(含查詢結果、錯誤信息)寫入文件。
-- 導入到同結構表
LOAD DATA INFILE 'D:\\log1.txt' INTO TABLE aa.log2 FIELDS TERMINATED BY ',';
-- 完整參數示例
LOAD DATA INFILE '/tmp/fi.txt' INTO TABLE test.fii
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n';
FIELDS TERMINATED BY:字段分隔符OPTIONALLY ENCLOSED BY:字段包裹符(數值型無效)LINES TERMINATED BY:行結束符