Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT

还是记录一下

Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT

当数据库添加两个字段类型使用timestamp时报上面的错误

Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT

 

原因是选择timestamp类型时,下面根据当前时间戳更新默认勾选,只能设置一个,所以设置第二个时会报错误

上一篇:云计算_kind部署看K8s集群


下一篇:MySql插入报错Incorrect integer value: '' for column