phone, validation_code, code_time, apply_time
delete from cab_validation_code
where phone = #{phone,jdbcType=VARCHAR}
insert into cab_validation_code (phone, validation_code, code_time, apply_time
)
values (#{phone,jdbcType=VARCHAR}, #{validationCode,jdbcType=VARCHAR}, #{codeTime,jdbcType=TIMESTAMP}, #{applyTime,jdbcType=TIMESTAMP}
)
insert into cab_validation_code
phone,
validation_code,
code_time,
apply_time,
#{phone,jdbcType=VARCHAR},
#{validationCode,jdbcType=VARCHAR},
#{codeTime,jdbcType=TIMESTAMP},
#{applyTime,jdbcType=TIMESTAMP},
update cab_validation_code
validation_code = #{validationCode,jdbcType=VARCHAR},
code_time = #{codeTime,jdbcType=TIMESTAMP},
apply_time = #{applyTime,jdbcType=TIMESTAMP},
where phone = #{phone,jdbcType=VARCHAR}
update cab_validation_code
set validation_code = #{validationCode,jdbcType=VARCHAR},
apply_time = #{applyTime,jdbcType=TIMESTAMP},
code_time = #{codeTime,jdbcType=TIMESTAMP}
where phone = #{phone,jdbcType=VARCHAR}