本地部署的大屏迁移到服务器上去报语法有误,应该是不符合 MariaDB 规范,这个有什么解决办法吗?
Request processing failed: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘tcm WHERE tcm.template_id in ( select id from visual…’ at line 1 ### The error may exist in class path resource [mybatis/ExtVisualizationTemplateMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: delete from visualization_template_category_map tcm WHERE tcm.template_id in ( select id from visualization_template vt where vt.name = ?) ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘tcm WHERE tcm.template_id in ( select id from visual…’ at line 1 ; bad SQL grammar []