gaofengai8 发表于 2009-8-31 13:00:33

kider 发表于 2009-9-1 09:33:18

不能用getdate()，如果想要默认值为当前时间，用timestamp吧

gaofengai8 发表于 2009-9-1 10:07:49

kider 发表于 2009-9-1 10:16:00

依据：
The DEFAULT clause specifies a default value for a column. With one exception, the default value must be a constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. The exception is that you can specify CURRENT_TIMESTAMP as the default for a TIMESTAMP column.
页: [1]
查看完整版本: mysql 的getdate()问题