Spring Data Jpa 中使用Mysql的存在则更新Sql
@Transactional @Repository public interface XXXRepository extends JpaRepository, JPASpecificationExecutor { @Modifying @Query(value="INSERT INTO tb_user (name,nick_name, mail) VALUES ('kevin','kevin', '[email protected]') ON DUPLICATE KEY UPDATE nick_name='kevin',mail='[email protected]'", nativeQuery=true) Integer saveAndUpdate(String name, String nickName, String mail); }
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)