Mysql--Row 235 doesn't contain d

工作需要将测试用例导入数据库，将excel文件转成.csv，并且用以下命令执行：

load data infile '~/Desktop/test.csv' into table test_case_pool fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';

遭遇如题报错。苦搜无果，最后用了梯子才找到办法。
执行下面两条sql就可以：

show variables like 'sql_mode';
set sql_mode='';