Skip to main content
100%

Gist 5567358

✓ Published0🌍 Public
HHoffmannP
Last edited May 13, 2013
Created on May 13, 2013

This visualization demonstrates how SQL handles null values in comparison and assignment operations. It shows the distinct results of various null-checking predicates—including `<=>`, `IS NULL`, `IS NOT NULL`, and `ISNULL`—combined with `IF` logic and the `IFNULL` function. The query executes against a single-row dataset containing the value `1`, then uses `GROUP BY ... WITH ROLLUP` to produce aggregated output, highlighting differences between MySQL’s null-safe equality operator and standard null checks. The gallery example relies on standard SQL execution, with no additional charting or graphics libraries involved.

AI-generated description

Similar vizzes