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.


Dynamic Page QR Code

Popular Posts

My LinkedIn PingTag

View My Stats