While SQLITE provides the same functionally as the traditional result = (condition) ? value-if-true : value-if-false, it does not support such syntax. The general syntax is:



For example, here's the correct SQLITE ternary syntax to check for a NULL value before incrementing it:



If myValue is not NULL, set myValue to myValue +1, ELSE initialize it to 1.

0 comments:

Dynamic Page QR Code

Popular Posts

My LinkedIn PingTag


View My Stats