mysql> use ddj_test Database changed mysql> show tables; +--------------------+ | Tables in ddj_test | +--------------------+ | calendar | +--------------------+ 1 row in set (0.00 sec) mysql> show fields from calendar; +-----------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+--------------+------+-----+---------+-------+ | cal_date | datetime | YES | | NULL | | | cal_descr | varchar(255) | YES | | NULL | | | cal_owner | varchar(255) | YES | | NULL | | +-----------+--------------+------+-----+---------+-------+ 3 rows in set (0.00 sec)
Example 2: Obtaining database information in MySQL using the show command.