/**
1.上一期+1个月和当前期不相等,同时排除还款日是当月的最后1天
2.还有待还款的数据
*/
SELECT CONCAT(‘update t_loan_repayment_history set predict_repayment_date = \”,DATE_ADD((SELECT predict_repayment_date FROM t_loan_repayment_history WHERE loan_id = c.loan_id
ORDER BY PERIODS
ASC LIMIT 1),INTERVAL c.PERIODS
-1 MONTH),’\’ where id = \”,c.ID
,’\”,’ and PERIODS = ‘,c.PERIODS
,’;’) AS usql
FROM t_loan_repayment_history a,t_loan_repayment_history b ,t_loan_repayment_history c
WHERE a.loan_real_id = c.loan_real_id
AND b.loan_real_id = c.loan_real_id
AND a.periods+1= b.periods
AND b.periods = c.PERIODS
-1
AND
(
DATE_ADD(a.predict_repayment_date,INTERVAL 1 MONTH) <> b.predict_repayment_date
OR
DATE_ADD(b.predict_repayment_date,INTERVAL 1 MONTH) <> c.predict_rep