Skip to content

Instantly share code, notes, and snippets.

@diaolizhi

diaolizhi/insert.java

Last active January 7, 2019 12:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save diaolizhi/8bab65ceff8a0e10189ed2c6b02b1744 to your computer and use it in GitHub Desktop.
Save diaolizhi/8bab65ceff8a0e10189ed2c6b02b1744 to your computer and use it in GitHub Desktop.
Download ZIP
mysql 插入数据时如果存在主键则只更新
Raw
insert.java
@Insert("INSERT INTO t_email_link VALUES (#{email}, #{link}, DATE_ADD(CURDATE(), INTERVAL 2 DAY))" +
"ON DUPLICATE KEY UPDATE link=#{link}, exp=DATE_ADD(CURDATE(), INTERVAL 2 DAY)")
void saveEmailAndChangePasswordLink(@Param("email") String email, @Param("link") String link);
//重点是 ON DUPLICATE KEY UPDATE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment