The Employees database is available from Employees DB on GitHub(登录该网站下载). You can download a prepackaged archive of the data, or access the information through Git.
To use the Zip archive package, download the archive and unpack it using WinZip or another tool that can read .zip
files, then change location into the unpacked package directory. For example, using unzip, execute these commands:
如果用的是MobaXterm,直接拖动到/root下然后解压。
$> unzip test_db-master.zip
$> cd test_db-master/
The Employees database is compatible with several different storage engines, with the InnoDB engine enabled by default. Edit the employees.sql
file and adjust the comments to choose a different storage engine:
选择其中一个存储模式
set storage_engine = InnoDB;
-- set storage_engine = MyISAM;
-- set storage_engine = Falcon;
-- set storage_engine = PBXT;
-- set storage_engine = Maria;
To import the data into your MySQL instance, load the data through the mysql command-line tool:
mysql -t -pMySQL_Password< employees.sql #MySQL_Password是MySQL的密码。自动生成employees schema库。30多万条数据足够学习使用了。