Web lists-archives.com

Re: find any row with NULL

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


MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql