Caused by: java.sql.SQLSyntaxErrorException: Unknown column name in field list

最新推荐文章于 2025-10-01 05:30:00 发布
原创 最新推荐文章于 2025-10-01 05:30:00 发布 · 3.4w 阅读 · 3 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍了解决MyBatis开发过程中遇到的SQL语法错误的具体步骤。主要针对未知列名导致的问题，提供了检查XML配置文件、实体类及数据库字段的一系列方法。

开发中查询时  出现这种错误      Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'name' in 'field list'      

解决方法： mybatis 的xml文件中出现了与数据库表中的字段不匹配。没有匹配上，也就是mybatis没有找到某字段对应的映射关系，请大家仔细认真排查，xml文件或实体类，或数据库字段。提醒大家此情况在开发中注意！耐心解决。

 

java.sql.SQLSyntaxErrorException: Unknown column ‘###‘ in ‘field list‘
猿小白的博客
09-10 2万+
今天遇到这么一个异常信息，开发环境是使用的mybatis，经过简单翻译，得到解决问题的大致方向 由上图得到的信息，可以大概知道我们定义的实体对象与我们的数据库表字段没有一一对应，也就是说，没有找到对应的匹配字段，所以就报了这样一个错误，但是经过仔细的比对，仍然没有发现问题所在，经过逐步排查，最终在设计表字段的地方发现了问题，主要原因就是：在设计表的时候，在字段后面多加了一个空格，由于空格是不...
解决 java.sql.SQLSyntaxErrorException:Unknown column ‘xxx‘ in ‘field list‘的问题
念兮为美
08-21 1万+
今天在调用`/auth/login`方法，报出错误：java.sql.SQLSyntaxErrorException: Unknown column 'permission1_.permission_value' in 'field list'。在解决该问题的过程中，并理解阿里巴巴java规约中的MySQL的建表规约。
Error updating database. Cause: java.sql.SQLSyntaxErrorException粗心惹的祸，解决问题的方法是拿截屏把各个层的代码进行比较，发现其中的差异
weixin_54048131的博客
02-08 2959
"code": 1,这句话的意思是：【产品代码】:1、 “消息“:“嵌套异常为org . Apache . ibatis . binding . binding异常:找不到参数“密码“。可用参数为【md5String，param1，username，param2】“， 【数据】:空。
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column ‘*****‘
FZD的博客
10-01 992
从错误信息中的 SQL 语句可以看到，查询时尝试获取 `user_photo_url` 字段： ```sql SELECT ..., user_photo_url, ... FROM user WHERE ... ``` 但数据库提示 `Unknown column 'user_photo_url' in 'field list'`，说明这个字段**并未实际添加到数据库表中**。``` 如果结果中没有 `user_photo_url`，说明之前的 `ALTER TABLE` 语句未成功执行。
java 数据可连接失败抛出异常_spring和mybatis结合，数据库连接池抛出异常
weixin_39895481的博客
02-16 380
org.mybatis.spring.MyBatisSystemException:nestedexceptionisorg.apache.ibatis.exceptions.PersistenceException:###Errorupdatingdatabase.Cause:org.springframework.jdbc.CannotGetJdbcConnectionEx...
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'name' in 'field list'
A_Little_xu的博客
04-08 2560
Caused by: java.sql.SQLSyntaxErrorException: Unknown column ‘name’ in ‘field list’ 测试出现错误，我自己今天往数据库插入数据时发现一直报这个错误，数据库数据插不进去，找了半天才发现是数据库表字段有空格，把空格取消就行了。这个是我自己建数据库的空格问题，就是这个空格导致我插不如数据。如果有空格就会报上面这个错误，解决...
【异常】MySQL提示`java.sql.SQLSyntaxErrorException: Unknown column ‘id‘ in ‘field list‘
本本本添哥
05-16 298
文章摘要： 在Spring框架中执行SQL查询时，程序报错java.sql.SQLSyntaxErrorException: Unknown column 'id' in 'field list'，表明查询的omo_pages表中不存在id列。可能原因包括表结构与查询语句不匹配、数据库与代码版本不一致、字段名拼写错误或连接了错误的数据库。解决方法包括：确认表结构、修改SQL查询语句、检查数据库连接配置以及同步数据库和代码。例如，若实际主键字段为page_id，需将查询语句中的id替换为page_id。若问题
java.sql.SQLSyntaxErrorException问题常见解决方案：比如Table xxx doesn‘t exist；Unknown column ‘xxx‘ in ‘where...
热门推荐
念兮为美
08-15 1万+
解决 bad SQL grammar [xxx]; nested exception is java.sql.SQLSyntaxErrorException: 1. Table xxx doesn't exist 2. You have an error in your SQL syntax；3. Unknown column x in x 4.Unknown column 'xxx' in 'where clause'。
springboot 集成activiti （Unknown column ‘VERSION_‘ in ‘field list‘）
weixin_44076260的博客
05-12 3385
目录 1.具体的错误 2.如果你的activiti-spring-boot-starter是7.1.0.M5的话，多半就会报错，很明显sql少字段，这个应该是一个官方的BUG，解决办法如下： 2.1.在 act_re_deployment中加两个字段就好了： VERSION_和 PROJECT_RELEASE_VERSION_ 然后重新运行就ok了 2.2.修改activiti-spring-boot-starter的版本，改为7.0.0.Beta2的 1.具体的错误 j...
OpenJDK 64-Bit Server VM warning: Sharing is only supported for boot loader classes because bootstrap classpath has been appended org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'descriptions' in 'field list' ### The error may exist in com/swt/spring_ssmp/dao/BookDao.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,type,name,descriptions FROM book WHERE id=? ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'descriptions' in 'field list' ; bad SQL grammar [] at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:246) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:107) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439) at jdk.proxy2/jdk.proxy2.$Proxy66.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:87) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at jdk.proxy2/jdk.proxy2.$Proxy69.selectById(Unknown Source) at com.swt.spring_ssmp.BookDaoTest.TestGetByID(BookDaoTest.java:20) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'descriptions' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:80) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:65) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:336) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:158) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:110) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:90) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:154) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:142) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:75) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:569) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425) ... 10 more
06-14
具体错误信息：`Unknowncolumn'descriptions'in'fieldlist'`原因分析：这个异常通常发生在Spring执行SQL语句时，SQL语法与数据库不匹配。具体错误信息表明，在SQL语句中引用了一个不存在的列`descriptions`。解决...
==> Parameters: 11:04:30.956 [main] ERROR druid.sql.Statement - [statementLogError,148] - {conn-10005, pstmt-20005} execute error. select id,product_id,central_id, product_name, product_code, create_by, create_time, update_by, update_time, deleted, comp_id,central_id, ip_address,ip_port,tray_weight,database_type from cct_production_line where deleted = 0 java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy295.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at com.sun.proxy.$Proxy293.query(Unknown Source) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy292.query(Unknown Source) at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy292.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) at com.sun.proxy.$Proxy146.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy167.selectProductionLineList(Unknown Source) at com.erp.product.service.impl.BasicDataServiceImpl.productionLineRedis(BasicDataServiceImpl.java:68) at com.erp.product.service.impl.BasicDataServiceImpl.basicDataRead(BasicDataServiceImpl.java:51) at com.erp.product.init.ClientInit.run(ClientInit.java:39) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:759) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:749) at org.springframework.boot.SpringApplication.run(SpringApplication.java:314) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) at com.erp.product.ErpProductApplication.main(ErpProductApplication.java:24) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4a8e6e89] 11:04:31.244 [main] INFO c.a.c.n.r.NacosServiceRegistry - [deregister,95] - De-registering from Nacos Server now... 11:04:31.252 [main] INFO c.a.c.n.r.NacosServiceRegistry - [deregister,115] - De-registration finished. 11:04:31.685 [main] INFO c.b.d.d.DynamicRoutingDataSource - [destroy,211] - dynamic-datasource start closing .... 11:04:31.702 [main] INFO c.a.d.p.DruidDataSource - [close,2138] - {dataSource-1} closing ... 11:04:31.711 [main] INFO c.a.d.p.DruidDataSource - [close,2211] - {dataSource-1} closed 11:04:31.712 [main] INFO c.b.d.d.DynamicRoutingDataSource - [destroy,215] - dynamic-datasource all closed success,bye 11:04:31.796 [main] ERROR o.s.b.SpringApplication - [reportFailure,821] - Application run failed java.lang.IllegalStateException: Failed to execute ApplicationRunner at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:762) at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:749) at org.springframework.boot.SpringApplication.run(SpringApplication.java:314) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292) at com.erp.product.ErpProductApplication.main(ErpProductApplication.java:24) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49) at org.springframework.boot.loader.Launcher.launch(Launcher.java:108) at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) Caused by: org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' ### The error may exist in class path resource [mapper/product/ProductionLineMapper.xml] ### The error may involve com.erp.product.mapper.ProductionLineMapper.selectProductionLineList-Inline ### The error occurred while setting parameters ### SQL: select id,product_id,central_id, product_name, product_code, create_by, create_time, update_by, update_time, deleted, comp_id,central_id, ip_address,ip_port,tray_weight,database_type from cct_production_line where deleted = 0 ### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.$Proxy146.selectList(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) at com.sun.proxy.$Proxy167.selectProductionLineList(Unknown Source) at com.erp.product.service.impl.BasicDataServiceImpl.productionLineRedis(BasicDataServiceImpl.java:68) at com.erp.product.service.impl.BasicDataServiceImpl.basicDataRead(BasicDataServiceImpl.java:51) at com.erp.product.init.ClientInit.run(ClientInit.java:39) at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:759) ... 13 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'product_id' in 'field list' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59) at com.sun.proxy.$Proxy295.execute(Unknown Source) at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64) at com.sun.proxy.$Proxy293.query(Unknown Source) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy292.query(Unknown Source) at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:151) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy292.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 24 common frames omitted怎么解决这个错误
最新发布
10-18
我们面对的问题：Java程序执行SQL查询时报错'Unknown column 'product_id' in 'field list'。 这个错误表示在数据库表中不存在名为'product_id'的列。 根据引用[1][2][3][4]中的信息，我们可以总结出以下常见原因...
Cause: java.sql.SQLSyntaxErrorException: Unknown column
qq_35930739的博客
12-20 1万+
本地数据库版本是：8.0.30。线上数据库版本是：8.0.29。
java.sql.SQLSyntaxErrorException: Unknown column name ‘ in ‘field list‘
qq_52563451的博客
07-05 2182
java.sql.SQLSyntaxErrorException: Unknown column name ‘ in ‘field list‘
Caused by: java.sql.SQLSyntaxErrorException: Unknown column ‘xxx‘ in ‘field list‘
m0_64284147的博客
11-19 3871
1、报错 2、不懂英文的可以用百度翻译、有道翻译、QQ在线翻译（快捷键Ctrl+Alt+O）等工具帮助翻译 大致意思是你写的sql语句的字段在数据库列表里没找到 3、原因 sql语句里的字段和数据库里的字段名字不匹配，有可能是你sql语句里的字段名写错了或写多了 4、解决办法 把你sql语句里的字段名改成与数据库里的字段名同名或把你sql语句里的字段名删了 ...
【问题解决】java.sql.SQLSyntaxErrorException: Unknown column ‘xxx‘ in ‘field list‘
JohnMin的博客
03-30 1万+
报错信息： Caused by: java.sql.SQLSyntaxEnnonException Create breakpoint : Unknown column 'xxx' in 'field list' Caused by: java.sql.SQLSyntaxEnnonException Create breakpoint : Unknown column ‘xxx’ in ‘field list’ 原因： sql语句里的字段和数据库里的字段名字不匹配，有可能是sql语句里的字段名写错了或写多
若依 Error querying database. Cause: java.sql.SQLSyntaxErrorException:
weixin_54048131的博客
07-29 4181
原因:Java . SQL . sqlsyntaxerrorexception:“字段列表”中的未知列“TPL _ web _ type”# # #错误可能存在于URL[jar:file:/home/my project/ruoyi-Java/ruoyi-admin . jar！嵌套异常是Java . SQL . sqlsyntaxerrorexception:“字段列表”中的未知列“tpl_web_type”
评论 8
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值