溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

MySQL安裝示例employee數(shù)據(jù)庫(kù)

發(fā)布時(shí)間：2020-05-24 07:21:18 來(lái)源：網(wǎng)絡(luò) 閱讀：755 作者：sky9890 欄目：MySQL數(shù)據(jù)庫(kù)

服務(wù)器操作系統(tǒng)：CentOS release 6.8 (Final)

數(shù)據(jù)庫(kù)系統(tǒng)：MySQL 5.5.52

任務(wù)：安裝employee示例數(shù)據(jù)庫(kù)

操作步驟:

[root@sky9896 ~]# wget https://launchpadlibrarian.net/24493586/employees_db-full-1.0.6.tar.bz2

[root@sky9896 ~]#tar jxf employees_db-full-1.0.6.tar.bz2

[root@sky9896 ~]# cd employees_db

[root@sky9896 employees_db]# mysql -uroot  -p  -t <employees.sql    #導(dǎo)入數(shù)據(jù)庫(kù)

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 |

+------------------+

[root@sky9896 employees_db]# time mysql -uroot  -p  -t < test_employees_sha.sql   #驗(yàn)證數(shù)據(jù)庫(kù)

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 |

| titles       |           443308 | d12d5f746b88f07e69b9e36675b6067abb01b60e |

| salaries     |          2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |

+--------------+------------------+------------------------------------------+

+--------------+------------------+------------------------------------------+

| table_name   | found_records    | found_crc                                |

+--------------+------------------+------------------------------------------+

| employees    |           300024 | 4d4aa689914d8fd41db7e45c2168e7dcb9697359 |

| departments  |                9 | 4b315afa0e35ca6649df897b958345bcb3d2b764 |

| dept_manager |               24 | 9687a7d6f93ca8847388a42a6d8d93982a841c6c |

| dept_emp     |           331603 | d95ab9fe07df0865f592574b3b33b9c741d9fd1b |

| titles       |           443308 | d12d5f746b88f07e69b9e36675b6067abb01b60e |

| salaries     |          2844047 | b5a1785c27d75e33a4173aaa22ccf41ebd7d4a9f |

+--------------+------------------+------------------------------------------+

+--------------+---------------+-----------+

| table_name   | records_match | crc_match |

+--------------+---------------+-----------+

| employees    | OK            | ok        |

| departments  | OK            | ok        |

| dept_manager | OK            | ok        |

| dept_emp     | OK            | ok        |

| titles       | OK            | ok        |

| salaries     | OK            | ok        |

+--------------+---------------+-----------+

real    0m19.958s

user    0m0.005s

sys     0m0.009s


向AI問一下細(xì)節(jié)
推薦閱讀：
  1. mysql安裝
  2. mysql安裝腳本

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手