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.