Dear friends, I have a database spec, I have pasted details from command prompt, to see structure of table I use following commands.
use spec show tables describe account The last command displays the structure of table, Now can you guide me to a command, where in I can see structure of all tables with that command. Like I use describe account some command like describe all tables so that i can see structure of all tables in database. Guidance, please. --------------------------------- Details of database and table structure and commands ------------------------------ mysql> use spec Database changed mysql> show tables -> ; +--------------------+ | Tables_in_spec | +--------------------+ | account | | datag | | developmentkashmir | | kashmirturmoil | | monthlyexpenses | | quiz | | words | +--------------------+ 7 rows in set (0.02 sec) mysql> describe account; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | username | varchar(50) | | | | | | password | varchar(50) | | | | | | email | varchar(50) | | | | | | confirmed | smallint(6) | | | 0 | | | random | varchar(50) | | | | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.04 sec) mysql>