Re: find any row with NULL

william drescher <[email protected]>
Newsgroups gmane.comp.db.mysql.general
Message-ID <[email protected]>
On 7/8/2016 9:15 AM, Johan De Meersman wrote:

> As a clear example of what it is useful for, imagine a situation where you're
performing an inventory on an existing warehouse. You have the 
list of all the
products they've ever sold, but you need to differentiate between 
'this product is
not in stock' (count = 0) and 'I have not counted this product 
yet' (count IS NULL).

Excellent example

-bill


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.