✍选择数据库

✍选择数据库
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)