07/18/2022, 8:41 PM
Upsert query in Dao I am developing an application using Room. The operation is simple, if the table has the same letter, the letterscore will increase by 1, otherwise it will be added and letterscore will be 0. In my Dao, I wrote a query as below to upsert the data, but it gives compound operator>, LIMIT, ORDER, comma or semicolon expected, got 'ON' error in the "ON" part: @Dao interface LetterDao { @Query("INSERT INTO letter_table(letter, letterScore) VALUES (:letter, :letterScore) ON CONFLICT(letter)...