当前位置：网站首页>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
边栏推荐
- New formdata() when importing files
- 最近编程中遇到的一些问题2021/9/8
- PHP background parsing after JQ serialization
- JQ序列化后PHP后台解析
- Parse PSD files and map them into components
- tp5 报错variable type error： array解决方法
- 常用sql语句收藏
- Your brain expands and shrinks over time — these charts show how
- freeCodeCamp----time_calculator练习
- leetcode刷题之二进制求和
猜你喜欢
随机推荐
mysql中sum (if)_mysql 中sum (if())
Header内置对象
Leak detection and vacancy filling (IV)
New formdata() when importing files
CentOS8搭建PHP8.0.3运行环境
Promise（三）
ASP.NET CORE 配置选项(上篇)
最近编程中遇到的一些问题2021/9/8
2021-09-18
excel里有文字的数字怎么从小到大排序，而不是首数字排序
freeCodeCamp----time_calculator练习
WebAPI+Form表单上传文件
关于注解1
New features of ES6
freeCodeCamp----shape_calculator练习
几款笔记软件的优缺点
【批量更改mysql表以及表中字段对应的编码】
Leak detection and filling (I)
Add serial number to El table
Leak detection and vacancy filling (IX) -- Procedure