How can php+mysql automatically insert a piece of data into the database at 0 o'clock every day?

Question

Suppose my database has a table with two fields

What I want to achieve is to automatically insert a piece of data into the database at 24:00 every day
For example, it turns out that
id=1
pv=0

I want to automatically insert one at 0 o'clock every day
id=2
pv=0

In another day,

will automatically insert one
id=3
pv=0

In another day,

will automatically insert one
id=4
pv=0

....

Does anyone understand this?

Answer 1

Method 1: Use mysql event to create a scheduled task

Reference: https://blog.codefun.cn/blog/...

Method 2: Use the scheduled task that comes with the operating system to execute the php script regularly

Method 3: Use nodejs or java or others which all come with scheduled tasks

Answer 2

crontab

Answer 3

linux scheduled task crontab