MySQL 8.0

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

create table inventory_procedure_log (
  id int unsigned auto_increment primary key,
  ts timestamp,
  fromDateTime datetime,
  rows_returned int
);
create procedure inventory_procedure (fromDateTime datetime)
begin
  -- random dummy result set
  select n
  from (select 1 n union select 2 union select 3) as x
  where rand() < 0.5;
  
  -- insert log entry
  insert into inventory_procedure_log(ts, fromDateTime, rows_returned) values (
    now(),
    fromDateTime,
    found_rows()
  );
end
call inventory_procedure('2022-06-06 12:00:00');
call inventory_procedure('2022-06-07 12:00:00');
call inventory_procedure('2022-06-08 12:00:00');


n


2




n


2

3




n


1

3


    select *
    from inventory_procedure_log
    where ts > now() - interval 24 hour


id
ts
fromDateTime
rows_returned


1
2025-06-20 22:54:48
2022-06-06 12:00:00
1

2
2025-06-20 22:54:48
2022-06-07 12:00:00
2

3
2025-06-20 22:54:48
2022-06-08 12:00:00
2

id	ts	fromDateTime	rows_returned
1	2025-06-20 22:54:48	2022-06-06 12:00:00	1
2	2025-06-20 22:54:48	2022-06-07 12:00:00	2
3	2025-06-20 22:54:48	2022-06-08 12:00:00	2