MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table tbl(
      id int, value int, dateStart timestamp, dateEnd timestamp
    );

    insert into tbl values
    (1, 4, '2020-01-04 16:29:00', '2020-01-04 16:33:00'),
    (2, 3, '2020-01-04 18:29:00', '2020-01-04 18:30:00'),
    (3, 3, '2020-07-16 09:10:00', '2020-07-16 09:12:00');
select * from tbl;


id
value
dateStart
dateEnd


1
4
2020-01-04 16:29:00
2020-01-04 16:33:00

2
3
2020-01-04 18:29:00
2020-01-04 18:30:00

3
3
2020-07-16 09:10:00
2020-07-16 09:12:00


with recursive cte as (
	select id, value, dateStart, dateEnd from tbl
	union all
	select id, value, dateStart + interval 1 minute, dateEnd 
	from cte
	where dateStart < dateEnd
)
select row_number() over(order by id) id, value, dateStart date 
from cte
order by id


id
value
date


1
4
2020-01-04 16:29:00

2
4
2020-01-04 16:30:00

3
4
2020-01-04 16:31:00

4
4
2020-01-04 16:32:00

5
4
2020-01-04 16:33:00

6
3
2020-01-04 18:29:00

7
3
2020-01-04 18:30:00

8
3
2020-07-16 09:10:00

9
3
2020-07-16 09:11:00

10
3
2020-07-16 09:12:00

id	value	dateStart	dateEnd
1	4	2020-01-04 16:29:00	2020-01-04 16:33:00
2	3	2020-01-04 18:29:00	2020-01-04 18:30:00
3	3	2020-07-16 09:10:00	2020-07-16 09:12:00

id	value	date
1	4	2020-01-04 16:29:00
2	4	2020-01-04 16:30:00
3	4	2020-01-04 16:31:00
4	4	2020-01-04 16:32:00
5	4	2020-01-04 16:33:00
6	3	2020-01-04 18:29:00
7	3	2020-01-04 18:30:00
8	3	2020-07-16 09:10:00
9	3	2020-07-16 09:11:00
10	3	2020-07-16 09:12:00