Roy's MYSQL Notes

Getting information about tables:

  {DESCRIBE | DESC} tbl_name [col_name | wild]
  SHOW {DATABASES | SCHEMAS} [LIKE 'pattern']
  SHOW [FULL|OPEN] TABLES [FROM db_name] [LIKE 'pattern']

http://www.johnstons.org/wdc/pub/resources/mysql_notes.html
July 9, 2005