[Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp

mysql5.6在cmd窗口中启动mysqld.exe时出现以下警告：

[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).

（中文大意：强烈建议不要使用带有隐式默认值的TIMESTAMP。请使用explicit_defaults_for_timestamp选项）

官方网站相关说明：

As indicated by the warning, to turn off the nonstandard behaviors, enable the newexplicit_defaults_for_timestamp system variable at server startup.

解决方案：

打开my.ini(可用记事本打开)，找到“[mysqld]”设置项，添加代码：

#开启查询缓存explicit_defaults_for_timestamp=true