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