程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> mysql outfile infile導入導出數據

mysql outfile infile導入導出數據

編輯:MySQL綜合教程

mysql outfile infile導入導出數據   導出 [plain]  SELECT * INTO OUTFILE '/tmp/jason.txt' FIELDS TERMINATED BY ',' FROM test.jason;     或者 [plain]  SELECT * INTO OUTFILE '/tmp/jason1.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM test.jason1;   輸出:         "2013-04-09 00:06:56","100000198108800","EXPORT_INFO","BUY_ITEM_INNER",65,10,1004,10,"11","2",100         "2013-04-09 00:06:59","1068029027","EXPORT_INFO","BUY_ITEM_INNER",16,7,304,7,"11","2",70         "2013-04-09 00:08:27","100000198108800","EXPORT_INFO","BUY_ITEM_INNER",65,2,1004,2,"11","2",20       導入 [plain]  LOAD DATA INFILE '/tmp/jason.txt' INTO TABLE aa.jason FIELDS TERMINATED BY ',';     或者   [plain]  LOAD DATA INFILE '/tmp/jason1.txt' INTO TABLE aa.jason1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';     總結: FIELDS TERMINATED BY ',' 字段間分割符 OPTIONALLY ENCLOSED BY '"' 將字段包圍 對數值型無效 LINES TERMINATED BY '\n' 換行符   mysqldump也有同樣功能   [plain]  mysqldump -uroot -p -T /tmp test fi --fields-enclosed-by=\" --fields-terminated-by="\t"     fi 是導出的文件名,默認添加.txt test 是要導出的庫名   -T /tmp 是導出的目錄位置   --fields-enclosed-by=\" 是每個數據都在雙引號裡面   --fields-terminated-by="\t" 表示每個數據是以制表符分割的

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved