Help for this page

Select Code to Download


  1. or download this
    CREATE TEMPORARY TABLE testnull0 (
  id INT NOT NULL auto_increment,
...
INSERT INTO testnull0 (id, value) VALUES (1, 'hello'), (2, 'googbye'),
+ (3, NULL);

SELECT COUNT(id), COUNT(value), COUNT(*) FROM testnull0;
  2. or download this
    +-----------+--------------+----------+
| COUNT(id) | COUNT(value) | COUNT(*) |
+-----------+--------------+----------+
|         3 |            2 |        3 |
+-----------+--------------+----------+