当前位置：网站首页>The time format is incorrect, and an error is reported when running the SQL file
The time format is incorrect, and an error is reported when running the SQL file
2022-04-23 06:52:00 【Collect and study by yourself】
The database time format uses datetime Format , This error is sent when the result is transferred , Because some data have no value to save 00-00-00 00:00:00, Wrong report , It's solved with this
set global sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
版权声明
本文为[Collect and study by yourself]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230555551631.html
边栏推荐
猜你喜欢
随机推荐
mysql中sum (if)_mysql 中sum (if())
PHP 无限极分类和树形
若依框架从零开始
js查找字符串中出现了三次的字符
1-2 NodeJS的特点
七牛上传图片（前台JS+后台C＃API获取token）
Solution to page cache problem (use with caution)
Set and map
The difference between VaR, let and Const
.Net Core 下使用 Quartz —— 【2】作业和触发器之初步了解作业
百度地图案例-修改地图样式
sqlserver性能优化建议
Header内置对象
freeCodeCamp----time_calculator练习
Aperçu de Redux
Promise（四）
并发优化请求
页面缓存问题解决方法（慎用）
Promise（一）
Mysql中的索引与视图