All sample databasesEmployees (browser edition)
Human Resources · employees.demodb.dev
Employees (browser edition)
sample database.
A reproducible, FK-closed browser-sized edition of the MySQL Employees sample, retaining 1,024 selected employees and their associated employment history.
-- Current department assignments
SELECT e.emp_no, e.first_name, e.last_name, d.dept_name,
6 tables · 2 views · 13,584 rows
-- 4 high-confidence cross-database table matches
6tables
2views
13,584table rows
Schema at a glance
Browse the recordsets.
table departments All nine departments in the source sample. 2 columns · 0 links · 9 rows table dept_emp Department assignments and date ranges for selected employees. 4 columns · 2 links · 1,127 rows table dept_manager All manager assignments in the source sample. 4 columns · 2 links · 24 rows table employees The selected employees from the pinned Employees sample, retaining their source identifiers and demographics. 6 columns · 0 links · 1,024 rows · 3 matches in other samples table salaries Salary history for selected employees. 4 columns · 1 links · 9,876 rows table titles Title history for selected employees. 4 columns · 1 links · 1,524 rows · 1 matches in other samples view current_dept_emp 4 columns · 0 links · 1,024 rows view dept_emp_latest_date 3 columns · 0 links · 1,024 rows
Downloads
Use this fixture
where you work.
Available files are generated from the provider’s pinned database contract. Pick a complete database or a single table.