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();