mysql测试没问题,但是tidb应该是不能设置’0000-00-00 00:00:00’为TIMESTAMP(0)的默认值,改成这样可以
CREATE TABLE t202(id INT,modified TIMESTAMP(0) NOT NULL ,
time_zone CHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ‘SYSTEM’);
mysql测试没问题,但是tidb应该是不能设置’0000-00-00 00:00:00’为TIMESTAMP(0)的默认值,改成这样可以
CREATE TABLE t202(id INT,modified TIMESTAMP(0) NOT NULL ,
time_zone CHAR(64) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT ‘SYSTEM’);