使用 phpmyadmin 将表结构导出到 Excel 文件

2022-01-05 00:00:00 mysql 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'

相关文章