I was creating a table with DATE field and I wanted default clause for it to be (CURDATE()). Here's how it is done in mysql CLI: mysql> CREATE TABLE `test` (`pdate` DATE DEFAULT (CURDATE())); Query OK ...