MySql 笔记 | 安装 Employees DB 的步骤

一、下载 Employees DB

---

环境：MySQL 5.7
我使用的 Employees DB：https://download.csdn.net/download/liupeifeng3514/10686248

Employees DB 官网地址：https://dev.mysql.com/doc/employee/en/employees-installation.html
Employees DB GitHub 地址：https://github.com/datacharmer/test_db

二、安装 Employees DB

---

将下载的压缩包解压后在MySQL命令行导入数据库：

Microsoft Windows [版本 10.0.17134.285]

B8613A@DESKTOP-9KNMTOD C:\Users\B8613A\Downloads\test_db-master\test_db-master
$ mysql -t -u root -p < employees.sql
Enter password: ****
+-----------------------------+
| INFO                        |
+-----------------------------+
| CREATING DATABASE STRUCTURE |
+-----------------------------+
+------------------------+
| INFO                   |
+------------------------+
| storage engine: InnoDB |
+------------------------+
+---------------------+
| INFO                |
+---------------------+
| LOADING departments |
+---------------------+
+-------------------+
| INFO              |
+-------------------+
| LOADING employees |
+-------------------+
+------------------+
| INFO             |
+------------------+
| LOADING dept_emp |
+------------------+
+----------------------+
| INFO                 |
+----------------------+
| LOADING dept_manager |
+----------------------+
+----------------+
| INFO           |
+----------------+
| LOADING titles |
+----------------+
+------------------+
| INFO             |
+------------------+
| LOADING salaries |
+------------------+
+---------------------+
| data_load_time_diff |
+---------------------+
| 00:00:40            |
+---------------------+

B8613A@DESKTOP-9KNMTOD C:\Users\B8613A\Downloads\test_db-master\test_db-master
$

三、查看导入结果

---

导入成功。