MySQL Mini DB

Small MySQL schema & sample queries for practice.

Files

• schema.sql: tables for a simple ticketing/helpdesk app
• queries.sql: example SELECT/INSERT/UPDATE queries
• db_demo.py: basic Python script to connect & run queries

Usage

-- create database
CREATE DATABASE minihelpdesk;
USE minihelpdesk;

-- run schema
SOURCE schema.sql;

-- run sample queries
SOURCE queries.sql;