I need to determine what is the equivalent for SQLite of the <=> operator in MySQL.
我需要确定MySQL中<=>运算符的SQLite的等价物。
Any idea?
2 个解决方案
#1
6
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)
#2
2
I have just found the "IS" operator, but not sure if it has exactly the same behaviour?
我刚刚找到了“IS”运算符,但不确定它是否具有完全相同的行为?
#1
6
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)
#2
2
I have just found the "IS" operator, but not sure if it has exactly the same behaviour?
我刚刚找到了“IS”运算符,但不确定它是否具有完全相同的行为?