1、查看有哪些数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| product |
| sys |
| xj |
+--------------------+
6 rows in set (0.00 sec)
2、选择数据库 product :
mysql> use product;
Database changed
3、 查看product 库下有哪些表
mysql> show tables;
+-------------------+
| Tables_in_product |
+-------------------+
| emp |
| goods |
| order_for_goods |
+-------------------+
3 rows in set (0.00 sec)
