You are here
TIMESTAMP with implicit DEFAULT value is deprecated
Sun, 2014-12-28 15:34 — oli
Hello all,
since MySQL 5.6 I get this nasty warning in my MySQL error log:
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
How dangerous is this warning hand how can I prevent it?
Taxonomy upgrade extras:
explicit_defaults_for_timestamp
The default behaviour is and was so far:
In MySQL 5.6 a new behaviour is introduced (not enabled by default) and the old behaviour will possibly deprecate sooner or later:
The old behaviour can still be mimicked but we have to specify it explicitly:
Our advice is to enable the variable
explicit_defaults_for_timestamp
now on your testing systems so you can see if your application behave well and then you are prepared for the next release when this feature will become the default.In short term this warning is NOT dangerous. In the long term you have to be prepared for the deprecated functionality. You get rid of the warning my setting
explicit_defaults_for_timestamp = 1
in yourmy.cnf [mysqld]
section.