CREATE TEMPORARY TABLE testnull0 (
  id INT NOT NULL auto_increment,
  value VARCHAR(100),
  PRIMARY KEY(id)
)
ENGINE=MyISAM;

INSERT INTO testnull0 (id, value) VALUES (1, 'hello'), (2, 'googbye'), (3, NULL);

SELECT COUNT(id), COUNT(value), COUNT(*) FROM testnull0;