Skip to content

Last modified: May 7, 2025

NULL Values

Relational databases allow a special value NULL
Interpretation depends on the application: NULL could mean “Not applicable” or “unknown” or “hidden” or “not collected” or many other things

NULL or True = True

  • This expression will always be true

Is NULL equal to NULL?

  • no. bc NULL can be ✨anything✨

special syntax to test for NULL:

  • “x IS NULL” evaluates to True if x is NULL