MySQL 数量庞大的Sample Table

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多万条数据足够学习使用了。

 原文见:MySQL :: Employees Sample Database :: 3 Installation

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值