将MySQL表导出到csv文件 [英] Exporting MySQL table into a csv file

问题描述

我有一个MySQL表，必须作为一个csv文件，我使用的查询是

I have a MySQL table which has to be taken out as a csv file, The query i used is

SELECT "ID","NAME","SALARY","SAL1","SAL2","SAL3","SAL4","SAL5","SAL6","SAL7","SAL8","SAL9","SAL10","SAL11","SAL12","SAL13","SAL14","SAL15","SAL16","SAL17","SAL18","SAL19","SAL20","SAL21","SAL22","SAL23","SAL24","SAL25","SAL26"
UNION ALL
SELECT *
FROM addstock25
INTO OUTFILE "E:\\JOSE DATA\\addstock7.csv"
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n

这个查询是有效的，如果我有200个列名，怎么办？
有没有办法手动输入？

This query works, what if i have a 200 column names ? Is there any way to do it without manually typing it ?

推荐答案

这个命令几乎给你你想要的，甚至可以与远程服务器一起工作。唯一的警告是它生成一个TSV文件通过标签）。

This command almost gives you what you want, and it even works with a remote server. The only caveat is that it generates a TSV files (fields are separated by a tab).

mysql mydb -e "select * from mytable" -B > mytable.tsv 

但您可以使用sed将其转换为CSV，如此回答

But you could convert it to CSV using sed, as suggested in this answer

mysql mydb -e "select * from mytable" -B | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" > mytable.csv

这篇关于将MySQL表导出到csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！