I was looking for a way to set a default value for a MySQL Datetime column. But it was not successful. Can someone please help?
In version 5.6.5, it is possible to set a default value on a datetime column, and auto update. The type definition:
CREATE TABLE foo (
`creation_time` DATETIME DEFAULT CURRENT_TIMESTAMP,
`modification_time` DATETIME ON UPDATE CURRENT_TIMESTAMP
It looks like you're new here. If you want to get involved, click one of these buttons!