mysql建表,时间字段设置默认值问题
create table ZXD_SB_RESULT_LOG
(
POLICYCODE VARCHAR(50),
CASEINT VARCHAR(50),
LINK VARCHAR(20),
CASEGRADE VARCHAR(10),
SBTIME TIMESTAMP,
ISSTTFLAG INT default 0,
INPUTTIME TIMESTAMP NOT NULL default CURRENT_TIMESTAMP
)
;
就这个普通语句,居然报错。mysql设置默认值就这么难吗
报错如下:
ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
请教怎么解决