可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):

问题:

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?

回答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.

1- FlightStats

2- MySql Version of NW schema (InnoDB)

3- MySql Version of NW schema (MyISAM)

4- more info

and a suggestion from mindplay.dk:

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

回答2:

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

回答3:

One option would be to export the actual Northwind DB to 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

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

回答4:

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

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

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

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

回答9:

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

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.

In case anyone else needs it, it can be found here

PD: I'm planning to migrate Adventureworks, Pubs and Contoso soon.