查数据库有哪些表、查数据库

mysql> SHOW TABLES;  //数据库有哪些表
+----------------+
| Tables_in_test |
+----------------+
| animals        |
| event          |
| pet            |
| shop           |
| t1             |
+----------------+
5 rows in set (0.00 sec)

 

mysql> show databases;   //查有哪些数据库
+--------------------+
| Database           |
+--------------------+
| information_schema |
| app                |
| bugzero_db         |
| mysql              |
| mysql_data         |
| new_db             |
| performance_schema |
| phpmyadmin         |
| sys                |
| test               |
| web                |
+--------------------+
11 rows in set (0.01 sec)