Re: My SQL catalog

[Paul McArdle]

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| cookbook |
| mysql |
| test |
| try |
| warmheart |
| world |
+--------------------+
7 rows in set (0.09 sec)

mysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| a |
| aaaa |
| animal |
| animal666 |
| b |
| companies |
| dt |
| employees |
| fund |
| houses |
| owners |
| people |
| pet |
| tbl |
| test_view |
| timecards |
| txt |
+----------------+
17 rows in set (0.02 sec)

mysql> desc pet;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| species | varchar(20) | YES | | NULL | |
| sex | char(1) | YES | | NULL | |
| birth | date | YES | | NULL | |
| death | date | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+
6 rows in set (0.04 sec)

mysql>