【异常】MySQL提示`java.sql.SQLSyntaxErrorException: Unknown column ‘id‘ in ‘field list‘

本本本添哥

于 2025-05-16 14:30:03 发布

阅读量50

点赞数

分类专栏： 003 - 数据库文章标签： mysql java 数据库

本文链接：https://blog.csdn.net/wstever/article/details/147999714

版权

003 - 数据库专栏收录该内容

357 篇文章 ¥19.90 ¥99.00

订阅专栏

超级会员免费看

一、报错内容

org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column 'id' in 'field list'
### The error may exist in com/xx/xxx/web/mapper/OmoPagesMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id, page_name_zh, page_name_en, page_name_id, is_enabled, page_order, is_homepage, delete_flag, remark, create_dept, create_by, create_time, update_by, update_time FROM omo_pages