weixin_57220518
2021-08-27 13:16
采纳率: 100%
浏览 83
已结题

sql执行报错 但在Navicat可以执行


<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

  • 收藏

3条回答 默认 最新

  • a1767028198 2021-08-27 14:16
    已采纳

    你这是拼sql就用${}吧

    已采纳该答案
    打赏 评论
  • 没壳的小蜗牛 2021-08-27 13:25

    远程连接数据库的权限问题吧

    打赏 评论
  • Zoey_C 2021-08-27 13:45

    看着像mysql驱动包的版本问题

    打赏 评论

相关推荐 更多相似问题