先看语句,对activationTime字段添加天数,增加的天数为(15-pospositionDpr)*90计算的结果
最终结果为activationTime新值=activationTime+(15-positionDpr)*90
UPDATE ma_users SET looktime_no = DATE_ADD(activationTime,INTERVAL (15-positionDpr)*90 day) WHERE `level` > 0;
先看语句,对activationTime字段添加天数,增加的天数为(15-pospositionDpr)*90计算的结果
最终结果为activationTime新值=activationTime+(15-positionDpr)*90
UPDATE ma_users SET looktime_no = DATE_ADD(activationTime,INTERVAL (15-positionDpr)*90 day) WHERE `level` > 0;