当前位置：网站首页>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

边栏推荐

猜你喜欢

随机推荐