From: Peter Brawley
Date: July 29 2005 6:24pm
Subject: Re: Database equivalent to NorthWind for M$ SQL
List-Archive: http://lists.mysql.com/mysql/187105
Message-Id: <42EA744F.8060002@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=======AVGMAIL-42EA74512A1F======="
--=======AVGMAIL-42EA74512A1F=======
Content-Type: multipart/alternative; boundary=------------060408060902020509060105
--------------060408060902020509060105
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Scott,
>Is there any database file similiar to M$'s Northwind that I can use to play
>with? It would be nice if there is one inside MySQL by default for newbies
>to start out with.
For our chapters on Connector/ODBC and dotNet, Arthur & I wrote scripts
to create MySQL versions of the NW schema ...
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html
(InnoDB) and
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html#11-2
(MyISAM).
If you like, I'll email you the SQL script for populating the tables.
PB
-----
Scott Hamm wrote:
>Is there any database file similiar to M$'s Northwind that I can use to play
>with? It would be nice if there is one inside MySQL by default for newbies
>to start out with.
>
>Microsoft's document often used Northwind as an example to teach functions.
>
>
>
>
>
>
>------------------------------------------------------------------------
>
>No virus found in this incoming message.
>Checked by AVG Anti-Virus.
>Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005
>
>
--------------060408060902020509060105
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Scott,
>Is there any database file similiar to M$'s Northwind that I can use to play
>with? It would be nice if there is one inside MySQL by default for newbies
>to start out with.
For our chapters on Connector/ODBC and dotNet, Arthur & I wrote
scripts to create MySQL versions of the NW schema ...
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html
(InnoDB) and
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1_appe.html#11-2
(MyISAM).
If you like, I'll email you the SQL script for populating the tables.
PB
-----
Scott Hamm wrote:
Is there any database file similiar to M$'s Northwind that I can use to play
with? It would be nice if there is one inside MySQL by default for newbies
to start out with.
Microsoft's document often used Northwind as an example to teach functions.
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005
--------------060408060902020509060105--
--=======AVGMAIL-42EA74512A1F=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005
--=======AVGMAIL-42EA74512A1F=======--