Answers for "date_add in mysql"

mysql add days to date

UPDATE classes 
SET `date` = DATE_ADD(`date`, INTERVAL 2 DAY)
WHERE id = 161

date_add mysql

Syntax:
DATE_ADD(date, INTERVAL value addunit)

Example:
SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR);

Output:
2020-11-22

mysql add days to date

UPDATE classes 
SET `date` = DATE_ADD(`date` , INTERVAL 2 DAY)
WHERE `id` = 161;

date_add mysql

SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR);

Output:
2020-11-22