mysql> select * from employee;
 +----+---------+--------+------------+
 | id | name    | salary | hiredate   |
 +----+---------+--------+------------+
 |  1 | Fran    | 100000 | 2006-05-01 |
 |  2 | Barry   |  90000 | 2006-04-01 |
 |  3 | Anna    |  80000 | 2006-01-01 |
 |  4 | Cynthia |  70000 | 2006-02-01 |
 |  5 | Enrico  |  60000 | 2006-03-01 |
 |  6 | Derek   |  50000 | 2006-06-01 |
 +----+---------+--------+------------+
 6 rows in set (0.00 sec)