mysql如何计算日期加减天数

select date_add(curdate(),interval 1 day) as tommorow; select date_add(curdate(),interval -1 day) as yestoday;