How to Update Date in each row with different dates in MySQL
If the goal is to have the following:




id
date
message




1
2021-05-26
There is no spoon.


2
2021-05-27
I know kung fu.


3
2021-05-28
zOMG! A Nokia 8801!


4
2021-05-29
Anything you'd like, Mr. Reagan.


5
2021-05-30
Follow the white rabbit.


6
2021-05-31
Not like this.




... then I would suggest taking a look at the DATE_ADD() function and using the id value as the INTERVAL amount.