<select id="putAppAnalysisTaskOutfile" >
load data local infile #{putFilePath}
into table app_analysis_task
fields terminated by '|' lines terminated by '＼n'
(<include refid="appAnalysisTaskUsedColumns"/>)
</select>
void putAppAnalysisTaskOutfile(@Param("putFilePath") String putFilePath);
mybatis执行报错，但sql在Navicat可以执行
org.springframework.jdbc.BadSqlGrammarException:
Error querying database. Cause: java.sql.SQLSyntaxErrorException: The used command is not allowed with this MySQL version
The error may exist in file [E:xxxx.xml]
The error may involve defaultParameterMap
The error occurred while setting parameters
SQL: load data local infile ? into table app_analysis_task fields terminated by '|' lines terminated by '＼n' ( name,market,app_num_threshold,create_time,end_time,process_percent,status,type_num,total_app_num,app_ratio,download_order )
Cause: java.sql.SQLSyntaxErrorException: The used command is not allowed with this MySQL version
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: The used command is not allowed with this MySQL version
SHOW VARIABLES LIKE '%local%';
local_infile ON
