We are providing the company database as a MySQL sample database to help you work with MySQL quickly and effectively. It contains typical company data such as employees data. This database is very simple and easy to understand.
We are using company sample database in our MySQL tutorials.
Download MySQL Sample Database
You can download the MySQL sample database in the following link:
MySQL Sample Database (2.58 kB)
The download file is in ZIP format so you need a extract it.
After extract the companysampledatabase.zip file, you can load the sample database into MySQL database server by following how to load sample database into MySQL database server tutorial and test it by using the following SQL statements:
1
| SHOW DATABASES; /*Return all database's name which is loaded in MySQL Server*/ |
1
2
| USE company; /*To set default database*/SELECT * FROM employees; |
Those queries switch the current database to company database and fetch data from employees table.
If you see the employees data returned, you have successfully imported the sample database into the MySQL database server.
MySQL Sample Database Schema
The MySQL sample database schema consists of the following tables:
- Department: stores department’s data.
- Branches: stores a list of company’s branches.
- Employees: stores all employee information as well as the organization structure such as who reports to whom.
In next tutorial we will learn how to load MySQL database using MySQL Workbench.
Install MySQL Database Server Load Sample Database
Install MySQL Database Server Load Sample Database
