[Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
来源:互联网 发布:手机光绘软件 编辑:程序博客网 时间:2024/06/09 20:35
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
0 0
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
- TIMESTAMP with implicit DEFAULT value is deprecated
- MySQL命令行启动报错[Warning] TIMESTAMP with implicit DEFAULT value is deprecated
- MySQL异常:TIMESTAMP with implicit DEFAULT value is deprecated
- [Warning] TIMESTAMP with implicit DEFAULT value
- MySQL 5.6 中TIMESTAMP with implicit DEFAULT value is deprecated错误
- warning: push.default is unset; its implicit value is changing in
- warning: push.default is unset; its implicit value has changed in Git 2.0 from 'matching' to 'simple
- Warning: $HADOOP_HOME is deprecated.
- Warning: $HADOOP_HOME is deprecated.
- [Warning] '--default-character-set' is deprecated and will be removed in a future release
- Warning: $HADOOP_HOME is deprecated. 关闭
- Warning:$HADOOP_HOME is deprecated问题
- Warning: $HADOOP_HOME is deprecated. hadoop
- Warning: $HADOOP_HOME is deprecated解决方法
- spring quartz 集群配置
- 数据结构-Queue
- 我的学习目标
- 3/7/2015
- 【连通图|强连通分量+缩点】POJ-1236 Network of Schools
- [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.explicit_defaults_for_timestamp
- node-webkit中js连接sqlite3文件型数据库
- 【node.js学习】--(7)--安装Mongodb
- 每日反省
- C零散_摘自C程序设计_结构体中.和->区别
- 1.Two Sum
- STL transform() demo
- HDU 2095--Find your present (2) 【set】
- ps for mac 破解版安装