56,678
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 65 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bbs |
| bookstore |
| datastruct |
| hospital |
| jspdev |
| mysql |
| test |
+--------------------+
8 rows in set (0.00 sec)
mysql> use bookstore;
Database changed
mysql> show tables;
+---------------------+
| Tables_in_bookstore |
+---------------------+
| allorder |
| book |
| bookadmin |
| bookclass |
| orders |
| sequence |
| shop_user |
+---------------------+
7 rows in set (0.00 sec)
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| bbs |
| bookstore |
| datastruct |
| hospital |
| jspdev |
| mysql |
| test |
+--------------------+
8 rows in set (0.00 sec)
mysql> use hospital;
Database changed
mysql> show tables;
+--------------------+
| Tables_in_hospital |
+--------------------+
| administrator |
| appointment |
| curappointment |
| doctor |
| history |
| patient |
| pinqueue |
+--------------------+
7 rows in set (0.01 sec)
mysql>
mysql> select table_name from `INFORMATION_SCHEMA`.`TABLES` where table_name ='t
5' and TABLE_SCHEMA='test';
+------------+
| table_name |
+------------+
| t5 |
+------------+
1 row in set (0.06 sec)