exporting table structure to Excel files with phpm

问题:

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?

Edit: it's my 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'

why it return an empty file?

回答1:

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'

回答2:

I had the same problem and I achieved with the combination of PHPMyadmin and a chrome plugin. This might not be the straightforward way but it just works. (Assuming you are using Google Chrome)

• Install Table capture for chrome - https://chrome.google.com/webstore/detail/table-capture/iebpjdmgckacbodjpijphcplhebcmeop/related?hl=en

• Once the plugin is installed, open PHPmyadmin > DB > table > click on Structure

• Right cLick on Print View > open in a new tab( this is important as the chrome plugin doesn't work on tables in an iframe)

• once the print view opens in a new tab, click on the plugin icon in the address bar,

• Click on the plugin icon and you will be shown options to either copy table to clipboard or export to Google docs.

• I did a copy and pasted the table into excel. You can also export to google docs.

Note: This is just a workaround and just wanted to share this. Please be easy on comments & TD's :) , and I like the way proposed by eggyal anyways!

回答3:

You don't need a plugin to copy and paste to Excel.

1. In phpmyadmin select the table you want to export the schema from
2. Click on Print View at the bottom of the page
3. Select the entire (or partial) table and click ctrl-c to copy
4. Open a new Excel worksheet and select the first cell
5. Click ctrl-v to paste

回答4:

Nowadays, phpmyadmin has an export format called CSV for Microsoft Excel, which makes it all automatically, you just need to click export on a table view and choose the format.