用phpmyadmin将表结构导出到Excel文件 [英] exporting table structure to Excel files with phpmyadmin
本文介绍了用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 '\n'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'dt_user'
为什么返回空文件?
推荐答案
您可以运行 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 '\n'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'my_table'
这篇关于用phpmyadmin将表结构导出到Excel文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文