NULL – The database’s black hole
21 Comments
I once read a scientific article on black holes that started of on the observation that, since a hole is the absence of anything and black is invisible in space, a black hole is in fact an invisible nothing – so what the heck are we talking about? Well, almost the same can be said about NULL in databases. Let’s first take a look at what NULL is supposed to be. Here is the definition of NULL from the SQL-2003 standard: null value: A special value that is used to indicate the absence of any data value.…
Read More
