com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘category1_id‘ in ‘where c

最新推荐文章于 2023-04-19 10:06:10 发布

明月常新

最新推荐文章于 2023-04-19 10:06:10 发布

阅读量592

点赞数

分类专栏：错误文章标签： java spring intellij-idea

本文链接：https://blog.csdn.net/weixin_45905210/article/details/123353297

版权

错误专栏收录该内容

12 篇文章 1 订阅

订阅专栏

问题描述

总是去到第一张表查找？？？

### The error occurred while setting parameters
### SQL: SELECT  id,name  FROM base_category1    WHERE  category1_id = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'category1_id' in 'where clause'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'category1_id' in 'where clause'

问题原因

CV的时候就改了后边前边的接口名字没有改

   @Autowired
    private BaseCategory1Mapper baseCategory1Mapper;

    @Autowired
    private BaseCategory2Mapper baseCategory2Mapper;

    @Autowired
    private BaseCategory3Mapper baseCategory3Mapper;