SQLite中等效的null安全等式运算符是什么？

I need to determine what is the equivalent for SQLite of the <=> operator in MySQL.

我需要确定MySQL中<=>运算符的SQLite的等价物。

Any idea?

2 个解决方案

#1

The IS and IS NOT operators work like = and != except when one or both of the operands are NULL. In this case, if both operands are NULL, then the IS operator evaluates to 1 (true) and the IS NOT operator evaluates to 0 (false)

除非一个或两个操作数都为NULL,否则IS和IS NOT运算符的工作方式类似于=和!=。在这种情况下,如果两个操作数均为NULL,则IS运算符求值为1(true),IS NOT运算符求值为0(false)

http://www.sqlite.org/lang_expr.html#isisnot

#2

I have just found the "IS" operator, but not sure if it has exactly the same behaviour?

我刚刚找到了“IS”运算符,但不确定它是否具有完全相同的行为?

#1