domenica 1 novembre 2009

Mysql and the default value of a TIMESTAMP column

The DEFAULT value in CREATE TABLE specification indicates a default value for a column.

The default value must be a constant and 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(). The solution is to specify CURRENT_TIMESTAMP as the default for a TIMESTAMP column.

Nessun commento:

Posta un commento