Mysql 打咩comment 去export一個 csv file?

2006-12-04 10:31 pm
Mysql 打咩comment 去export一個 csv file?
....

回答 (2)

2006-12-04 11:28 pm
✔ 最佳答案
Here is an example that produces a file in the comma-separated values (CSV) format used by many programs:

SELECT a,b,a+b INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ’”’
LINES TERMINATED BY '\n\r'
FROM test_table;
2006-12-04 10:40 pm
exe.csv


收錄日期: 2021-04-13 14:46:38
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061204000051KK01539

檢視 Wayback Machine 備份