timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
I have a timestamp in mysql table to record the timestamp of the update (insert/update etc.)
But if the data is not added by "insert" but the data is added through "load data local infile", the timestamp would stay to be "01/01/0001 12:00:00 am".
Any advices?
Thanks!