1 CREATE TABLE IF NOT EXISTS `test` (
2 `id` INTEGER UNSIGNED PRIMARY KEY AUTO_INCREMENT,
3 `nullable` TIMESTAMP NULL
9 `nullable` = CASE @nullable WHEN 0 THEN NULL ELSE @nullable END
13 INSERT INTO `test` SET `nullable` = IFNULL(@nullable, 0);
16 SELECT `id`, NULLIF(`nullable`, 0) `nullable` FROM `test`;