phpmyadmin导出到csv的excel [英] phpmyadmin exporting to csv for excel

问题描述

我有问题使用xampp（4.1.6）phpmyadmin导出功能。当我导出时，我选择csv为excel格式，但它将返回如下数据：

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:

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?

顺便说一下，下面是我的phpmyadmin

By the way, below is the interface of my phpmyadmin export function.

我试图将它导出为正常的csv，但它仍然返回相同，更糟糕的是，所有的数据都放在第一行。

I tried to export it as normal csv, but it still return the same. even worse, ALL the data is put inside 1st row.

推荐答案

你几乎是正确的，你只需要检查把colums名称在第一行复选框，然后开始导出。

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.

由于你的努力，你应该做这项工作。

:

你的self你可以得到字段名与这个MYSQL查询：

Since your doin it your self you can get the fieldnames with this MYSQL query:

    SELECT `COLUMN_NAME` 
FROM `INFORMATION_SCHEMA`.`COLUMNS` 
WHERE `TABLE_SCHEMA`='yourdatabasename' 
    AND `TABLE_NAME`='yourtablename';

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