1DROP TABLE IF EXISTS t1; 2SET sql_mode='NO_ENGINE_SUBSTITUTION'; 3SET TIME_ZONE="+03:00"; 4CREATE TABLE t1(c1 DATE NOT NULL PRIMARY KEY); 5SET TIMESTAMP=1171346973; 6INSERT INTO t1 (c1) VALUES(NOW()); 7Warnings: 8Note 1265 Data truncated for column 'c1' at row 1 9INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 10Warnings: 11Note 1265 Data truncated for column 'c1' at row 1 12INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'); 13Warnings: 14Note 1265 Data truncated for column 'c1' at row 1 15Note 1265 Data truncated for column 'c1' at row 1 16SELECT * FROM t1; 17c1 182007-02-14 192007-02-15 20DROP TABLE t1; 21CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY); 22INSERT INTO t1 (c1) VALUES(1999); 23INSERT INTO t1 (c1) VALUES(2000); 24INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011; 25SELECT * FROM t1; 26c1 272000 282011 29DROP TABLE t1; 30CREATE TABLE t1(c1 TIME NOT NULL PRIMARY KEY); 31SET TIMESTAMP=1171346973; 32INSERT INTO t1 (c1) VALUES(NOW()); 33INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 34INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'); 35SELECT * FROM t1; 36c1 3710:10:34 3811:10:34 39DROP TABLE t1; 40CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY); 41INSERT INTO t1 (c1) VALUES(1999); 42INSERT INTO t1 (c1) VALUES(2000); 43INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011; 44SELECT * FROM t1; 45c1 462000 472011 48DROP TABLE t1; 49CREATE TABLE t1(c1 DATETIME NOT NULL PRIMARY KEY); 50SET TIMESTAMP=1171346973; 51INSERT INTO t1 (c1) VALUES(NOW()); 52INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 53INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'); 54SELECT * FROM t1; 55c1 562007-02-14 10:10:34 572007-02-15 11:10:34 58DROP TABLE t1; 59CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY); 60INSERT INTO t1 (c1) VALUES(1999); 61INSERT INTO t1 (c1) VALUES(2000); 62INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011; 63SELECT * FROM t1; 64c1 652000 662011 67DROP TABLE t1; 68CREATE TABLE t1(c1 TIMESTAMP NOT NULL PRIMARY KEY); 69SET TIMESTAMP=1171346973; 70INSERT INTO t1 (c1) VALUES(NOW()); 71INSERT INTO t1 (c1) VALUES(ADDTIME(NOW(),'1 01:01:01')); 72INSERT INTO t1 (c1) VALUES(NOW()) ON DUPLICATE KEY UPDATE c1=ADDTIME(NOW(),'2 02:01:01'); 73SELECT * FROM t1; 74c1 752007-02-14 10:10:34 762007-02-15 11:10:34 77DROP TABLE t1; 78CREATE TABLE t1(c1 YEAR NOT NULL PRIMARY KEY); 79INSERT INTO t1 (c1) VALUES(1999); 80INSERT INTO t1 (c1) VALUES(2000); 81INSERT INTO t1 (c1) VALUES(1999) ON DUPLICATE KEY UPDATE c1=2011; 82SELECT * FROM t1; 83c1 842000 852011 86DROP TABLE t1; 87SET TIME_ZONE= @@global.time_zone; 88SET sql_mode=default; 89