CREATE TABLE `employees` (

  `emp_no` int(11) NOT NULL,

  `birth_date` date NOT NULL,

  `first_name` varchar(14) NOT NULL,

  `last_name` varchar(16) NOT NULL,

  `gender` enum('M','F') NOT NULL,

  `hire_date` date NOT NULL,

  PRIMARY KEY (`emp_no`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

TRUNCATE TABLE employees; LOAD XML LOCAL INFILE 'dummy_data_no_whitespaces.xml' INTO TABLE employees;

-- takes a few seconds

TRUNCATE TABLE employees; LOAD XML LOCAL INFILE 'dummy_data.xml' INTO TABLE employees;

-- takes > 5 minutes, maybe hours