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 MySQL server version for the right syntax to use near 'ccv WHERE ccv.scene_id = 1175445105243459584 ’ at line 3 ### The error may exist in class path resource [mybatis/ExtDataVisualizationMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: DELETE FROM snapshot_core_chart_view ccv WHERE ccv.scene_id = ? and ccv.id not in ( ? , ? ) ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ccv WHERE ccv.scene_id = 1175445105243459584 ’ at line 3 ; bad SQL grammar []
在线安装的版本，MySQL5.7.44，之前都正常