Create table fail in mysql when using CURDATE() as default

Viewed 21451

I'm trying to create the following table using phpmyadmin sql console:

CREATE TABLE dates
(
id int NOT NULL,
id_date datetime NOT NULL DEFAULT CURDATE(),
PRIMARY KEY (id)
)

However I get the following error: alt text

It shows "CURDATE()" in red, so I guess that's the problem.

Could anyone help me out here ?

1 Answers
Related