By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `employee` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`date_employment` date DEFAULT NULL,
`date_dismissal` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
INSERT INTO `employee` (`id`, `date_employment`, `date_dismissal`) VALUES
(1, '2022-01-01', NULL),
(2, '2022-02-20', NULL),
(3, '2022-03-01', '2022-06-01'),
(4, '2022-04-20', '2022-05-01'),
(5, '2022-05-01', NULL),
(6, '2022-06-01', NULL);
select * from employee
| id | date_employment | date_dismissal |
|---|---|---|
| 1 | 2022-01-01 | null |
| 2 | 2022-02-20 | null |
| 3 | 2022-03-01 | 2022-06-01 |
| 4 | 2022-04-20 | 2022-05-01 |
| 5 | 2022-05-01 | null |
| 6 | 2022-06-01 | null |