更新MySQL查询以在7天前移动数据

Question

I have this website programmed with PHP and of course using MySQL as the Database Tool. I need to move my data one back back or ahead.

The first image shows the set up I have right now.

And by clicking on the PUSH 1 WEEK link on the top right corner, the second image show what I want to accomplish. You can see that the information/data moved one week ahead.

Third image shows my table scheme

Table Scheme

I would like to get help on how to word my UPDATE or what are the guidelines to accomplish this.

Thanks

Answer 1

Your task can be archived with a simple SQL statement (Source):

UPDATE table 
SET `date` = DATE_ADD(`date` , INTERVAL 7 DAY)
WHERE `id` = 161;

This adds 7 days to all entries that match the WHERE condition.