Sql - NULL Values
📖 Read the lesson
Code Life
By Pierre Marsaa
Understanding NULL Values
In SQL,
NULL
represents a missing or unknown value. It's not the same as zero, an empty string, or false.
NULL
is a
special
value that requires special handling.
Loading data...
Look at our Codémon table above. Some Codémons have
NULL
values for type, level, or power. For example:
- Florachu has a
NULL
level
- Pyrochu has a
NULL
power
- Shadowchu has a
NULL
type
What NULL Really Means
NULL means "we don't know" or "not applicable". For example, a
NULL
power might mean the Codémon's power is unknown or hasn't been determined.
Verify