Why would you default a field to NULL instead of just leaving the value empty? Is it merely so you can query IS NULL ?
I'm specifically asking about INT or other numerical data types
-
1Because there no EMPTY in INT - it is NULL insteadbensiu– bensiu2011-03-10 14:36:51 +00:00Commented Mar 10, 2011 at 14:36
Add a comment
|
3 Answers
Because there's a semantic difference between NULL and empty.
If a field is empty, how can you tell the difference between the following?
- the value is known to be empty
- the value is unknown
That's what NULL is for: if you don't know the value then use NULL; if you know the value -- empty or not -- then use it.
Comments
There's no such notion as "empty" in MySQL.
For example, an int column is either an integer, or NULL.
If you don't specify a default value for your int column, if you try to insert a new row without specifying something for this column, mysql will raise an error.
Comments
Define "leaving the value empty". An empty value is null. If you mean empty = 0, then think about an account (money wise). You can have an account with 0$ in it, but you also can have no account at all (null). There is a difference between 0 and null.
