Load Data into MySQL Sample Database

1. Select Database "classicmodels" (Default database name)

2. Load "load_classicmodels.sql" and press execute to load data.

Create MySQL Sample Database

1. Remove comments on the following statements to create database (if first time)

/* Recommended DATABASE name is classicmodels. */

CREATE DATABASE classicmodels;
USE classicmodels;

2. Comments out the following statment (if first time)

/* DROP the existing tables. Comment this out if it is not needed. */

/*
DROP TABLE Customers;
DROP TABLE Employees;
DROP TABLE Offices;
DROP TABLE OrderDetails;
DROP TABLE Orders;
DROP TABLE Payments;
DROP TABLE Products;
DROP TABLE ProductLines;
*/

3. Load "create_classicmodels.sql"into phpMyAdmin and press execute to run SQL.

MYSQL Sample Database

The database consists of eight tables:

* Offices: sales offices
* Employees: All employees, including sales reps.
* Customers
* Orders: Orders placed by customers
* Order Details: Line items within an order.
* Payments: Payments made by customers against their account
* Products: The list of scale model cars
* Product Lines: The list of product line classification

The sample database is open source; you are free to use it for your own use to experiment with other tools.


http://www.eclipse.org/birt/phoenix/db/#mysql