weixin_45670589的博客

【代码】记MySQL中if条件语句以及include标签的用法。

MYSQL求最大最小值

select FINA_ID AS finaId, START_DATE AS startDate, END_DATE AS endDate, REMIND_DAYS AS remindDays from t09_zj_fina_prod_info finawhere fina.VALID_STATUS = "1"<if t

如果FINA_PROD_TYPE不为03时，修改表设置字段REMIND_DAYS为输入的值，否则设置为nullUPDATE t09_zj_fina_prod_infoSET REMIND_DAYS =CASE WHEN FINA_PROD_TYPE !='03' THEN #{remindDays} ELSE NULL END```

批量查询数据的sql语句包括根据数字转成汉字、日期计算<select id="queryFinaByIds" parameterType="cn.com.git.dgmsfund.api.entity.bo.finance.finaExcelBO" resultType="cn.com.git.dgmsfund.api.entity.bo.finance.finaExcelBO">select FINANCIAL_INSTITUTION AS financialInstitution