[RESOLVED] DESCRIBE to output as text in phpMyAdmin 2.6.1

[steamPunk]

Hi

when i do "DESCRIBE tablename" in the SQL pane of phpMyAdmin 2.6.1 it generates an html table - is there any way i can force it to output the information in text form like in the manual ? - like this :

+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+

thanks

[NogDog]

I'm not aware of a way to do that. However, you can get something similar by clicking the "Export" tab, checking "SQL" in the "Export" section and unchecking "Data" in the "SQL Options" section (while leaving "Structure" checked). Leave "Save as File" unchecked and click "Go". You'll get something like:

CREATE TABLE `pommo_config` (
  `config_name` varchar(64) collate latin1_bin NOT NULL default '',
  `config_value` text collate latin1_bin NOT NULL,
  `config_description` tinytext collate latin1_bin NOT NULL,
  `autoload` enum('on','off') collate latin1_bin NOT NULL default 'on',
  `user_change` enum('on','off') collate latin1_bin NOT NULL default 'on',
  PRIMARY KEY  (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

[steamPunk]

ok thanks