本文介绍了一种使用MySQL命令将数据库表数据导出为CSV文件的方法。具体命令为：SELECT * INTO OUTFILE '/tmp/products.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '' ESCAPED BY '\' LINES TERMINATED BY '
' FROM products;该命令说明了字段如何被逗号分隔，如何用双引号括起来以及如何转义特殊字符等。
SELECT *
INTO OUTFILE '/tmp/products.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM products
文件存放在DATA目录里
[b]FYI[/b]
[url]http://www.electrictoolbox.com/mysql-export-data-csv/[/url]
INTO OUTFILE '/tmp/products.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM products
文件存放在DATA目录里
[b]FYI[/b]
[url]http://www.electrictoolbox.com/mysql-export-data-csv/[/url]
扫一扫
1170
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
