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?
9 Answers
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)
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
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
Related