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