UPDATE `mytable` SET  time2 = DATE_ADD(time1,INTERVAL 1 DAY)
WHERE status=1
Logo

更多推荐