NULL

noun

say it: “NUL” /nʌl/

A marker in a database for a missing or unknown value, which is not the same as zero or empty text.

What is NULL in a relational database?

NULL — A marker indicating that a value is missing or unknown, rather than zero or an empty string.

SELECT customer_id
FROM customer
WHERE phone_number IS NULL;

In a sentence

  • “Some customers have no fax number, so their Fax column is NULL.”

Level: Novice · More SQL terms at this level

Updated

In other subjects