6.9. OUTFILE/LOAD DATA INFILE

6.9. OUTFILE/LOAD DATA INFILE
上一頁	第 6 章 SQL Statement Syntax	下一頁

查詢結果輸出到檔案

SELECT * FROM tablename INTO OUTFILE '/tmp/tablename.txt';

使用tee將屏幕輸出到檔案

		
mysql>tee /home/neo/screen.txt
mysql>select * from user;
mysql>exit

		
SELECT * INTO OUTFILE '/home/mark/Orders.txt'
　　FIELDS
　　TERMINATED BY = ','
　　FROM Orders
　　WHERE Order_Date >= '2000-01-01'

		
LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table;

6.9.1. Export data to CSV from MySQL

SELECT *
INTO OUTFILE '/tmp/products.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM products

6.9.2. Import data from CSV file.

LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:\\hx.csv' IGNORE INTO TABLE `tmp`.`creditlog`
CHARACTER SET gbk FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n'
(`ctime`, `login`, `mode`, `type`, `prevavailcredit`, `change`, `newavailcredit`, `comment`);

上一頁	上一級	下一頁
6.8. UNION	起始頁	6.10. CASE Syntax