MySQL是否有“北风”类型的数据库?

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吗?

10 个解决方案

#1

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 - FlightStats

2- MySql Version of NW schema (InnoDB)

2- NW模式MySql版本(InnoDB)

3- MySql Version of NW schema (MyISAM)

3- MySql版本的NW模式(MyISAM)

4- more info

4 -更多信息

and a suggestion from mindplay.dk:

还有头脑游戏的建议。

5- Northwind (schema+data, as provided by mnk below)

5-北风(模式+数据，如下mnk提供)

#2

You may download it from here: http://dev.wavemaker.com/forums/?q=node/4721

您可以从这里下载:http://dev.wavemaker.com/forums/?

#3

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:

此应用程序的目的是演示MySQL 4.1及其一些新的和更高级的特性。随着MySQL的成熟，这个应用程序也有望成熟。目前，以下特征被以一些有意义的方式使用:

Joins

连接

Subqueries

子查询

Subqueries in the FROM clause

子查询位于FROM子句中

Query cache

查询缓存

#4

Here's a version of Northwind for MySQL on GitHub. The column names have been slightly altered to fit the MySQL standard.

下面是GitHub上MySQL的北风版本。为了符合MySQL标准，对列名进行了轻微修改。

https://github.com/dalers/mywind

#5

Yes. Can be found here, for instance.

是的。例如，这里可以找到。

#6

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

so far this is the unique Northwind for MariaDB MySQL that works like a charm

到目前为止，这是MariaDB MySQL独特的北风，它的工作方式就像一种魅力。

no errors, no warnings,

没有错误,没有警告,

I link it since it is not listed in this thread

我链接它，因为它不在这个线程中列出

#7

http://marakana.com/download/sql/northwind.sql

#8

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

#9

There's a link at the beginning of the article where you can grab an SQL script with structure and data:

在本文的开头有一个链接，您可以获取具有结构和数据的SQL脚本:

http://www.geeksengine.com/article/export-access-to-mysql.html

#10

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 Codeplex to MySQL.

我知道这个问题是很久以前的事了，但是我需要特别关注一下MySQL。因此，我将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:我计划尽快把冒险场所、酒吧和社区搬到其他地方。

#1