MySql: Show, Desc, Info on Database and Table
January 14th, 2009 by jeremychoneShow Database
mysql> show databases
Show Tables
mysql> use my_database
mysql> show tables
mysql> show tables
or Show Table Status for more information
mysql> show table status
Describe Table
mysql> desc my_table