php phpmyadmin 导出到 csv 用于 excel
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/22399477/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
phpmyadmin exporting to csv for excel
提问by user2960754
I'm having problem using xampp (4.1.6) phpmyadmin export function. When I export, I select csv for excel format, but it will return the data like:
我在使用 xampp (4.1.6) phpmyadmin 导出功能时遇到问题。当我导出时，我选择 csv 作为 excel 格式，但它会返回如下数据：
1;"data1";"0";"6828";"2014-03-13 13:54:26";"2014-03-13 13:54:26";"file";;"2014-03-14 14:45:51"
So I tried the syntax:
所以我尝试了语法：
SELECT * FROM `directory_listing`
INTO OUTFILE 'C:/test.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
Now the format is the same as the table view as in mysql table. Problem is, I want to display the column name on 1st row. How can i do that?
现在格式与mysql表中的表视图相同。问题是，我想在第一行显示列名。我怎样才能做到这一点？
By the way, below is the interface of my phpmyadmin export function.
顺便说一句，下面是我的phpmyadmin导出功能的界面。
I tried to export it as normal csv, but it still return the same. even worse, ALL the data is put inside 1st row.
我试图将它导出为普通的 csv，但它仍然返回相同的内容。更糟糕的是，所有数据都放在第一行。
回答by ThatMSG
You almost got it right, you just have to check the "Put colums names in first row" checkbox and then start the export. That should do the job.
您几乎做对了，您只需选中“将列名称放在第一行”复选框，然后开始导出。那应该可以完成这项工作。
EDIT::
编辑：：
Since your doin it your self you can get the fieldnames with this MYSQL query:
既然你自己做，你就可以通过这个 MYSQL 查询获得字段名：
SELECT `COLUMN_NAME`
FROM `INFORMATION_SCHEMA`.`COLUMNS`
WHERE `TABLE_SCHEMA`='yourdatabasename'
AND `TABLE_NAME`='yourtablename';
回答by Mahbub
Just check the Put columns names in the first rowcheckbox above the Gobutton.
只需选中按钮Put columns names in the first row上方的复选框Go即可。
