1UPDATE classes
2SET `date` = DATE_ADD(`date`, INTERVAL 2 DAY)
3WHERE id = 161
1Syntax:
2DATE_ADD(date, INTERVAL value addunit)
3
4Example:
5SELECT DATE_ADD("2017-11-22", INTERVAL 3 YEAR);
6
7Output:
82020-11-22
1UPDATE classes
2SET `date` = DATE_ADD(`date` , INTERVAL 2 DAY)
3WHERE `id` = 161;