mysql 的getdate()问题
请大侠帮我看看，这个语句死活调不通：create table orders(
ordersId bigint auto_increment ,
orderDate datedefault getdate() ,
totalPrice float not null,
primary key (ordersId)
);
commit;
就是getdate()这块老有问题 不能用getdate()，如果想要默认值为当前时间，用timestamp吧 2# kider
谢谢老哥 依据：
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]