CURRENT_TIMESTAMP on create only

Database management in a single PHP file

Brought to you by: jakubvrana

Status: closed-works-for-me

Owner: Jakub Vrána

Labels: MySQL (74)

Priority: 5

Updated: 2013-01-12

Created: 2012-12-30

Private: No

There should be a way to choose, to have the CURRENT_TIMESTAMP inserted into column only on row create, not update.

Jakub Vrána - 2013-01-12

status: open --> closed-works-for-me
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jakub Vrána - 2013-01-12

Just set the default value of timestamp column to CURRENT_TIMESTAMP (instead of default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP).

If you would like to refer to this comment somewhere else in this project, copy and paste the following link: