July 23, 2012

MySql – how to remove on update current_timestamp

Example:

Table Name: tbl_user
Field Name: user_created

Solution:

ALTER TABLE tbl_user CHANGE `user_created` `user_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

Last updated: March 19, 2014