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.