mysql 的getdate()问题

gaofengai8

请大侠帮我看看，这个语句死活调不通：


create table orders(

ordersId bigint auto_increment ,
orderDate date  default getdate() ,
totalPrice float not null,
primary key (ordersId)
);
commit;


就是getdate()这块老有问题

kider

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

gaofengai8

2# kider


谢谢老哥

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.