是否有可用于 MySQL 的“Northwind”类型数据库？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2036395/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Is there a "Northwind" type database available for MySQL?
提问by Josh Stodola
I need some test data for a MySQL utility that I am creating. Does anybody know where I can find one that has a similiar (if not more) amount of data as Northwind for SQL Server?
我需要一些我正在创建的 MySQL 实用程序的测试数据。有谁知道我在哪里可以找到与 SQL Server 的 Northwind 具有类似（如果不是更多）数据量的数据？
采纳答案by Michel Gokan
UPDATE:
更新：
This is an answer for about 4 years ago and links were dead because of time, I'll put new links as soon as I find some.
这是大约 4 年前的答案，链接因时间而失效，我会在找到一些新链接后立即添加。
1- FlightStats
1-飞行统计
2- MySql Version of NW schema (InnoDB)
3- MySql Version of NW schema (MyISAM)
4- more info
4-更多信息
and a suggestion from mindplay.dk:
以及来自 mindplay.dk 的建议：
5- Northwind(schema+data, as provided by mnk below)
5- Northwind（架构+数据，由下面的 mnk 提供）
回答by Abd Ul Aziz
You may download it from here: http://dev.wavemaker.com/forums/?q=node/4721
你可以从这里下载：http: //dev.wavemaker.com/forums/?q=node/4721
回答by DeegC
Here's a version of Northwind for MySQL on GitHub. The column names have been slightly altered to fit the MySQL standard.
这是 GitHub 上用于 MySQL 的 Northwind 版本。列名略有改动以符合 MySQL 标准。
回答by nickf
One option would be to export the actual Northwind DB to MySQL. http://www.geeksengine.com/article/export-access-to-mysql.html
一种选择是将实际的 Northwind 数据库导出到 MySQL。http://www.geeksengine.com/article/export-access-to-mysql.html
FlightStats seems to be another one you could use: http://flightstats.us/about.php
FlightStats 似乎是您可以使用的另一种：http: //flightstats.us/about.php
The purpose of this application is to demonstrate MySQL 4.1 and some of its new and more advanced features. As MySQL matures, it is the hope that this application will also mature. Currently, the following features are used in some meaningful way:
- Joins
- Subqueries
- Subqueries in the FROM clause
- Query cache
此应用程序的目的是演示 MySQL 4.1 及其一些新的和更高级的功能。随着 MySQL 的成熟，希望这个应用程序也能成熟。目前，以下功能以某种有意义的方式使用：
- 加入
- 子查询
- FROM 子句中的子查询
- 查询缓存
回答by Robert
I have tested quite all the dumps available in this thread with latest MariaDB but all of them were returning warnings or errors
我已经使用最新的 MariaDB 测试了该线程中可用的所有转储，但所有转储都返回警告或错误
searching out there I have found this
在那里搜索我发现了这个
http://www.dotnettwitter.com/2011/05/northwind-database-scripts-for-sql.html
http://www.dotnettwitter.com/2011/05/northwind-database-scripts-for-sql.html
so far this is the unique Northwind for MariaDB MySQLthat works like a charm
到目前为止，这是MariaDB MySQL的独特Northwind，它的作用就像一个魅力
no errors, no warnings,
没有错误，没有警告，
I link it since it is not listed in this thread
我链接它，因为它没有在这个线程中列出
回答by Sohail Qureshi
Yes. Can be found here, for instance.
是的。例如，可以在这里找到。
回答by ax003d
There is a sample database provided by MySQL: https://dev.mysql.com/doc/employee/en/index.html
MySQL 提供了一个示例数据库：https: //dev.mysql.com/doc/employee/en/index.html
回答by mnk
回答by Philipp Rieber
There's a link at the beginning of the article where you can grab an SQLscript with structure and data:
文章开头有一个链接，您可以在其中获取SQL包含结构和数据的脚本：
http://www.geeksengine.com/article/export-access-to-mysql.html
http://www.geeksengine.com/article/export-access-to-mysql.html
回答by Fahed
I know this question is from a long time ago, but I needed specifically Northwind on MySQL a while ago. So I migrated the structure and data on the current version of Northwind in Codeplexto MySQL.
我知道这个问题是很久以前的问题，但不久前我特别需要 MySQL 上的 Northwind。所以我将Codeplex中当前版本Northwind上的结构和数据迁移到了MySQL。
In case anyone else needs it, it can be found here
如果其他人需要它，可以在这里找到
PD: I'm planning to migrate Adventureworks, Pubs and Contoso soon.
PD：我计划很快迁移 Adventureworks、Pubs 和 Contoso。
