本文介绍了使用 phpmyadmin 将表结构导出到 Excel 文件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我将在 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 文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！