Set NOW() as Default Value for datetime datatype?
As of MySQL 5.6.5, you can use the DATETIME type with a dynamic default value: CREATE TABLE foo ( creation_time DATETIME DEFAULT CURRENT_TIMESTAMP, modification_time DATETIME ON UPDATE CURRENT_TIMESTAMP ) Or even combine both rules: modification_time DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP Reference: http://dev.mysql.com/doc/refman/5.7/en/timestamp-initialization.html http://optimize-this.blogspot.com/2012/04/datetime-default-now-finally-available.html Prior to 5.6.5, you need to use the TIMESTAMP data type, … Read more