使用 phpmyadmin 将表结构导出到 Excel 文件 [英] exporting table structure to Excel files with phpmyadmin

问题描述

我将在 Phpmyadmin 中从我的表结构创建一个 excel 文件(仅限结构).我发现它有一个 CSV 输出，但它只给我数据.
phpmyadmin 是否有任何功能可以做这样的事情?

I' going to create an excel file from my table structure in Phpmyadmin(structure only).I found that it has a CSV output but it gives me just data.
Does Phpmyadmin has any feature to do such a thing or not?

这是我的 sql:

SELECT * INTO OUTFILE 'c://wamp/my_table_structure.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES  TERMINATED BY '
'
FROM   INFORMATION_SCHEMA.COLUMNS
WHERE  TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'dt_user'

为什么它返回一个空文件?

why it return an empty file?

推荐答案

你可以运行一个 SELECT ... INTO OUTFILE 查询如下:

You could run a SELECT ... INTO OUTFILE query along the following lines:

SELECT * INTO OUTFILE '/path/to/my_table_structure.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES  TERMINATED BY '
'
FROM   INFORMATION_SCHEMA.COLUMNS
WHERE  TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'my_table'

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