加上一年 UPDATE TABLE SET FIELD = FIELD +numtoyminterval(1,'year') UPDATE TABLE SET FIELD = ADD_MONTHS(FIELD,12) 加上一月 UPDATE TABLE SET FIELD = FIELD +numtoyminterval(1,'month') UPDATE TABLE SET FIELD = ADD_MONTHS(FIELD,1)