How to Update Date in each row with different dates in MySQL I want to update date column of the table with dates in the increment of 1 for all rows.
How do I do it in MySQL?
Table: tbl_question_of_the_day
Column: date
So the output that I want is:
Row 1: Today
Row 2: Tomorrow
Row 3: Day after tomorrow
...and so on.
There is an ID column as primary key.
Thanks!
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.