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
13
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
5
You may download it from here: http://dev.wavemaker.com/forums/?q=node/4721
您可以从这里下载:http://dev.wavemaker.com/forums/?
#3
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
3
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
https://github.com/dalers/mywind
#6
2
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 MySQL that works like a charm
到目前为止,这是MariaDB MySQL独特的北风,它的工作方式就像一种魅力。
no errors, no warnings,
没有错误,没有警告,
I link it since it is not listed in this thread
我链接它,因为它不在这个线程中列出
#8
1
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
0
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
http://www.geeksengine.com/article/export-access-to-mysql.html
#10
0
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
13
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
5
You may download it from here: http://dev.wavemaker.com/forums/?q=node/4721
您可以从这里下载:http://dev.wavemaker.com/forums/?
#3
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
3
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
https://github.com/dalers/mywind
#5
#6
2
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 MySQL that works like a charm
到目前为止,这是MariaDB MySQL独特的北风,它的工作方式就像一种魅力。
no errors, no warnings,
没有错误,没有警告,
I link it since it is not listed in this thread
我链接它,因为它不在这个线程中列出
#7
#8
1
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
0
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
http://www.geeksengine.com/article/export-access-to-mysql.html
#10
0
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:我计划尽快把冒险场所、酒吧和社区搬到其他地方。