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"

所以我尝试了语法:

SELECT * FROM `directory_listing` 
INTO OUTFILE 'C:/test.csv' 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '
'

现在格式与mysql表中的表视图相同.问题是，我想在第一行显示列名.我该怎么做?

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.

推荐答案

您几乎做对了，您只需选中将列名称放在第一行"复选框，然后开始导出.这应该可以完成工作.

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.

:

既然你自己做，你就可以通过这个 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屋！