Auto add new data with default value for each day every 12 PM using MySQL and Codeigniter 4

Question

I am trying to create function to automatically adding rows every 12 PM each day for attendance record table, total data based on total employees, for example I have 5 employees, so I need function to adding 5 new rows with default value that I have set before.

here is my table:

Thanks for any ideas.

[Using the Event Scheduler](https://dev.mysql.com/doc/refman/8.0/en/event-scheduler.html) — Akina, Apr 19 '22 at 04:15
As Akina has suggested , using the event scheduler can carry out periodic jobs. If you can provide the actual `show create table xxxx` code instead of an image, people here may elaborate with an example. — blabla_bingo, Apr 19 '22 at 07:18

score 2 · Accepted Answer · answered Apr 19 '22 at 08:41

2

Just write php script for this work.

and scheduler it into Cron job.

You can following: Execute PHP script in cron job

answered Apr 19 '22 at 08:41

Hảo Nguyễn

111
3

Your answer could be improved by providing an example of the solution and how it helps the OP. – Tyler2P Apr 19 '22 at 09:52

Auto add new data with default value for each day every 12 PM using MySQL and Codeigniter 4

1 Answers1