MySQL安装示例employee数据库
服务器操作系统：CentOS> 数据库系统：MySQL 5.5.52任务：安装employee示例数据库
操作步骤:
# wget https://launchpadlibrarian.net/24493586/employees_db-full-1.0.6.tar.bz2
#tar jxf employees_db-full-1.0.6.tar.bz2
# cd employees_db
# mysql -uroot-p-t +----------------+
+------------------+
| INFO |
+------------------+
| LOADING salaries |
+------------------+
# time mysql -uroot-p-t < test_employees_sha.sql #验证数据库
Enter password:
+----------------------+
| INFO |
+----------------------+
| TESTING INSTALLATION |
+----------------------+
+--------------+------------------+------------------------------------------+
| table_name | expected_records | expected_crc |
+--------------+------------------+------------------------------------------+
| employees | 300024 | 4d4aa689914d8fd41db7e45c2168e7dcb9697359 |
| departments| 9 | 4b315afa0e35ca6649df897b958345bcb3d2b764 |
| dept_manager | 24 | 9687a7d6f93ca8847388a42a6d8d93982a841c6c |
| dept_emp | 331603 | d95ab9fe07df0865f592574b3b33b9c741d9fd1b |
|> | salaries | 2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |
+--------------+------------------+------------------------------------------+
+--------------+------------------+------------------------------------------+
| table_name | found_records | found_crc |
+--------------+------------------+------------------------------------------+
| employees | 300024 | 4d4aa689914d8fd41db7e45c2168e7dcb9697359 |
| departments| 9 | 4b315afa0e35ca6649df897b958345bcb3d2b764 |
| dept_manager | 24 | 9687a7d6f93ca8847388a42a6d8d93982a841c6c |
| dept_emp | 331603 | d95ab9fe07df0865f592574b3b33b9c741d9fd1b |
|> | salaries | 2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |
+--------------+------------------+------------------------------------------+
+--------------+---------------+-----------+
| table_name | records_match | crc_match |
+--------------+---------------+-----------+
| employees | OK | ok |
| departments| OK | ok |
| dept_manager | OK | ok |
| dept_emp | OK | ok |
|> | salaries | OK | ok |
+--------------+---------------+-----------+
real 0m19.958s
user 0m0.005s
sys 0m0.009s
页:
[1]