Skip to content

Instantly share code, notes, and snippets.

@parzibyte
Created November 22, 2020 03:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save parzibyte/dbbed9b7ba9e7eebabe5bcf322265831 to your computer and use it in GitHub Desktop.
Save parzibyte/dbbed9b7ba9e7eebabe5bcf322265831 to your computer and use it in GitHub Desktop.
MariaDB [attendance]> select * from employee_attendance;
+-------------+------------+----------+
| employee_id | date | status |
+-------------+------------+----------+
| 2 | 2020-11-15 | presence |
| 3 | 2020-11-15 | presence |
| 2 | 2020-11-16 | presence |
| 3 | 2020-11-16 | presence |
| 2 | 2020-11-17 | absence |
| 3 | 2020-11-17 | presence |
| 2 | 2020-11-20 | presence |
| 3 | 2020-11-20 | presence |
| 2 | 2020-11-21 | presence |
| 3 | 2020-11-21 | presence |
| 2 | 2020-11-19 | absence |
| 3 | 2020-11-19 | absence |
| 2 | 2020-11-18 | absence |
| 3 | 2020-11-18 | presence |
+-------------+------------+----------+
14 rows in set (0.000 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment