“dateAdded"的默认值无效 [英] Invalid default value for 'dateAdded'

问题描述

我遇到了一个无法修复的愚蠢的 SQL 问题.

I got a stupid problem with SQL that I can't fix.

ALTER TABLE  `news` 
 ADD  `dateAdded` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AUTO_INCREMENT ,
 ADD PRIMARY KEY (  `dateAdded` )

错误:

(#1067)Invalid default value for 'dateAdded'

有人可以帮我吗?

推荐答案

CURRENT_TIMESTAMP 仅适用于 TIMESTAMP 字段.DATETIME 字段必须保留空默认值，或者根本没有默认值 - 默认值必须是常量值，而不是表达式的结果.

CURRENT_TIMESTAMP is only acceptable on TIMESTAMP fields. DATETIME fields must be left either with a null default value, or no default value at all - default values must be a constant value, not the result of an expression.

相关文档:http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html

您可以通过在表上设置插入后触发器以在任何新记录上填充现在"值来解决此问题.

You can work around this by setting a post-insert trigger on the table to fill in a "now" value on any new records.

这篇关于“dateAdded"的默认值无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！