@Modifying marks a Spring Data repository query method as changing data rather than retrieving it. Use it with @Query when the query performs an INSERT, UPDATE, or DELETE. section 14.3 section 14.5
Listing 14.7 Defining a modifying operation in the repository
public interface AccountRepository
extends CrudRepository<Account, Long> {
@Query("SELECT * FROM account WHERE name = :name")
List<Account> findAccountsByName(String name);
@Modifying #A
@Query("UPDATE account SET amount = :amount WHERE id = :id")
void changeAmount(long id, BigDecimal amount);
}The repository method changes an account balance with an UPDATE query; @Modifying marks the operation as data-changing. section 14.3
