从5.7的windows服务器上迁移到5.7.22版本,报错了
[root@server-102 ~]# mysql3308 -S /tmp/mysql3308.sock -ugxsnerproot -p gxsnerp <gxsnerp_20180717.sql
Enter password:
ERROR 1292 (22007) at line 54980: Incorrect date value: '0000-00-00' for column 'SXKSSJ' at row 1
解决:
在[mysqld]部分添加sql_mode:
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES