Sample Databases

pubs

One of the databases provided for SQL Server, pubs, can also be used in MariaDB/MySQL.

Here is a script to create and populate the pubs table:

To create the pubs database on your local machine, follow the directions below:

• Download the pubs file above.
• Open phpMyAdmin.
  • Click the Import tab.
  • In the File to import section click the Browse button, locate your file (Pubs.sql or Northwinds.sql), and select it.
  • Check the Enable foreign key checks,
  • Click the Go button on the lower left.
• To see the relationships, click here.
• Note that if you don't have MariaDB/MySQL and phpMyAdmin installed on your computer, you can set up an account at https://remotemysql.com/. It creates a database and names it for you, so you will have to comment out the first three lines of SQL in the Pubs.sql file.

Northwind

You can install the northwind database in much the same way.

Here is a script to create and populate the northwind table:

• To see the relationships, click here.