Geek asks and answers

Export table structure to Excel files using phpmyadmin

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

Edit: this is 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 does it return an empty file?

+5
source share
3 answers

You can execute the query SELECT ... INTO OUTFILEin 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'
+9
source

I had the same problem and I reached with a combination of PHPMyadmin and a chrome plugin. It may not be simple, but simple. (Assuming you are using Google Chrome)

enter image description here

  • , ,

enter image description here

  • , Google.

enter image description here

  • excel. Google.

enter image description here

. . , TD:), , eggyal !

+6

You do not need a plugin to copy and paste in Excel.

  • In phpmyadmin, select the table from which you want to export the schema from
  • Click "Print View" at the bottom of the page.
  • Select the entire (or partial) table and press ctrl-c to copy
  • Open a new Excel worksheet and select the first cell
  • Press ctrl-v to paste
+4
source

More articles:


All Articles