Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Null value in Database

Tags:

rdbms

Null value means

  1. No value
  2. Inapplicable,unassigned, unknown, or unavailable

Which is true?


2 Answers

It's all about the context in which it's used. A null means there is no value but the reason for this will depend on the domain in which it is being used. In many cases the items you've listed are all valid uses of a null.

like image 65
Chris W Avatar answered Feb 01 '26 17:02

Chris W


It can mean any of those things (and it is not always obvious which), which is one argument against using nulls at all.

See: http://en.wikipedia.org/wiki/Null_(SQL)#Controversy

like image 29
finnw Avatar answered Feb 01 '26 16:02

finnw



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!