What is the difference between "=" and "==" in Room queries?

user_10813253 0
Viewed 266
@Query("SELECT * FROM table where age = :age")
fun getAge(age: Int)

@Query("DELETE FROM table where name == :name")
suspend fun deleteName(name: String): Int?

One query uses = and the other uses ==, I wanted to know if there is any difference between them?

android-room kotlin sqlite android database
2 Answers

There is practically no difference, the equals operator in sqlite has two variations, from SQL Language Expressions

Note that there are two variations of the equals and not equals operators. Equals can be either = or ==. The non-equals operator can be either != or <>.

user_44130980

As of now, it now matters.

  1. For where clause use the double i.e ==

  2. For set,update,delete clause use the single i.e =

user_80224360
Related