# Preparing a database table

In order to create a drop-down list in a Job in the following examples, you should have a Mysql database.

Before replicating the following examples, make sure you have created a Mysql table named employee. The table stores people information as shown below.

| id | name | email | sex | department | position |
| --- | --- | --- | --- | --- | --- |
| 1 | Elisa | elisa@company.com | F | RD | manager |
| 2 | Nicolas | nicolas@company.com | M | RD | developer |
| 3 | Sabrina | sabrina@company.com | F | Community | developer |
| 4 | Stephane | stephane@company.com | M | Sales | manager |
| 5 | Jim | jim@company.com | M | Sales | pre-sales |