Question 215463 in Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – ı am trying to write a sql query in spring boot

With spring boot, I want to delete data greater than 48 hours in the
database with a sql query.

I want to delete data in database more than 48 hours.

DELETE FROM schedule WHERE date_time < NOW() - INTERVAL 48 HOUR;

This query works fine in mysql, but I want to do it in spring boot.

@Query("DELETE FROM schedule WHERE date_time < NOW() - INTERVAL 48 HOUR")

i do it this way but i get error (‘(‘, or expected, got ’48’)

Tags:

2

Answers


  1. 0

    i think this one will be helpful,

    @Query(value = "DELETE FROM schedule WHERE date_time < NOW() - INTERVAL 48 HOUR", nativeQuery = true)
    Login or Signup to reply.
  2. 0

    Or you can use hibernate query language(HQL) instead of native query

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search