How to add timestamp with interval starting from Current time with interval 1 minutes for every row in MYSQL?

In example, I have something like,

for example, using NOW() will give time stamp "10/24/2022 12:00:00"
I want to add timestamp which will be something like

Would you please explain how to do that in mysql?
Thank you

>Solution :

We can use the TIMESTAMPADD() function here:

SELECT Number_index,
       TIMESTAMPADD(MINUTE, Number_index - 1, NOW()) AS Time_Stamp
FROM yourTable
ORDER BY Number_index;

The above is one option if you want view your output as described. If instead you want to update your table, then use:

UPDATE yourTable
SET Time_Stamp = TIMESTAMPADD(MINUTE, Number_index - 1, NOW());