mysql "org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database. Cause: java.sql.SQLSyntaxErro

根据异常信息，可以看出是SQL语句语法错误导致的。具体来说，错误在于SELECT语句中存在多余的逗号，导致MySQL无法解析该语句。 错误的SQL语句如下： ```sql SELECT tbModelClassification.*, tbLargeModel.*, FROM t_model_classification tbModelClassification LEFT JOIN t_model_large tbLargeModel ON tbModelClassification.id = tbLargeModel.classification_id WHERE tbModelClassification.deleted = 1 AND tbLargeModel.deleted = 1 ``` 可以看到，在SELECT语句中，tbLargeModel.*后面多了一个逗号，导致语法错误。应该将逗号删除，正确的SQL语句如下： ```sql SELECT tbModelClassification.*, tbLargeModel.* FROM t_model_classification tbModelClassification LEFT JOIN t_model_large tbLargeModel ON tbModelClassification.id = tbLargeModel.classification_id WHERE tbModelClassification.deleted = 1 AND tbLargeModel.deleted = 1 ``` 你需要修改Mapper XML文件中对应的SQL语句，将多余的逗号删除即可。