Spring Boot

[공통] 중복된 값 수정할때

root_go 2022. 12. 14. 11:17

INSERT INTO `member`.`users` (`id`, `nickname`, `registered_on`)

VALUES ('12123123' , '바뀐닉네임', NOW())

ON DUPLICATE KEY UPDATE `nickname` = '바뀐닉네임',

                                                    `registered_on` = NOW();