Navicat之后导入SQL时报了Incorrect datetime value: '0000-00-00 00:00:00.000000' 错误

首先新建一个查询，
show variables like 'sql_mode';
set global sql_mode='strict_trans_tables,no_zero_in_date,error_for_division_by_zero,no_auto_create_user,no_engine_substitution';
退出。重新导入即可
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION