mysql输入数据显示_mysql插入数据显示：Incorrect datetime value: '0000-00-00 00:00:00' 错误的处理...

最新推荐文章于 2022-06-19 13:39:22 发布

朝辞暮归

最新推荐文章于 2022-06-19 13:39:22 发布

阅读量315

点赞数

文章标签： mysql输入数据显示

本文链接：https://blog.csdn.net/weixin_29650949/article/details/113394792

版权

这个是因为mysql 版本兼容性问题引起的，需要在mysql做全局设置。

可以打开mysql命令窗口，做如下设置

mysql> select @@sql_mode ;

+-------------------------------------------------------------------------------------------------------------------------------------------+

| @@sql_mode |

+-------------------------------------------------------------------------------------------------------------------------------------------+

| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

+-------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set

mysql> set global sql_mode='strict_trans_tables,no_zero_in_date,error_for_division_by_zero,no_auto_create_user,no_engine_substitution';

Query OK, 0 rows affected

mysql> select @@sql_mode ;

+-------------------------------------------------------------------------------------------------------------------------------------------+

| @@sql_mode |

+-------------------------------------------------------------------------------------------------------------------------------------------+

| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |

+-------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set

关注