"NULL" is a special value

"NULL" is neither TRUE or FALSE

"NULL = NULL" evaluates to FALSE

"NULL IS NULL" evaluates to TRUE

Columns can be defined as "NULL" (default) or "NOT NULL"