How it is possible to set a default value for a MySQL Datetime column? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How it is possible to set a default value for a MySQL Datetime column?

Damian99Damian99 USAPosts: 116Member

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?

Tagged:

Comments

  • DavidMDavidM USAPosts: 342Member

    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
    )
    
Sign In or Register to comment.