The short answer
NULL means missing/unknown/not available.
It isn't:
0
''
FALSEAnd:
NULL = NULLdoesn't return TRUE.
Use:
IS NULLor:
IS NOT NULLExample:
WHERE manager_id IS NULLFree. Runs in your browser, no install.
SQL · NULL Handling & Data Types
What is NULL?
The short answer
NULL means missing/unknown/not available.
It isn't:
0
''
FALSEAnd:
NULL = NULLdoesn't return TRUE.
Use:
IS NULLor:
IS NOT NULLExample:
WHERE manager_id IS NULLLock it in with a real drill
You remember an answer longer once you have used it. Try a hands-on problem on this concept.