导入文件头部临时追加:
方法一:
set session sql_mode='STRICT_TRANS_TABLES';
方法二:
SET SESSION SQL_MODE = 'ONLY_FULL_
GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
导入文件头部临时追加:
方法一:
set session sql_mode='STRICT_TRANS_TABLES';
方法二:
SET SESSION SQL_MODE = 'ONLY_FULL_
GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';