错误记录：You have an error in your SQL syntax; check the manual that corresponds to your MySQL

最新推荐文章于 2024-02-23 18:52:11 发布

weixin_43625204

最新推荐文章于 2024-02-23 18:52:11 发布

阅读量371

点赞数

CC 4.0 BY-SA版权

分类专栏： ssh 文章标签： spring java

本文链接：https://blog.youkuaiyun.com/weixin_43625204/article/details/105981463

在尝试执行SQL语句时遇到错误提示：'You have an error in your SQL syntax...'，原因是使用了MySQL的关键字'condition'。博客详细讨论了这个问题，并提供了解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 'condition, price) values (101, '买', 40, '南京', '东', 300.0)' at line 1

condition在Mysql中是关键字

控制台信息：

20:40:37,617  WARN SqlExceptionHelper:144 - SQL Error: 1064, SQLState: 42000
20:40:37,617 ERROR SqlExceptionHelper:146 - 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 'condition, price) values (101, '买', 40, '南京', '东', 300.0)' at line 1
20:40:37,620 ERROR Dispatcher:38 - Exception occurred during processing request: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
	at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:146)
	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:344)
	at org.springframework.orm.hibernate4.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:309)
	at org.springframework.orm.hibernate4.HibernateTemplate.save(HibernateTemplate.java:618)
	at com.kim.dao.impl.RentbuyDaoImpl.save(RentbuyDaoImpl.java:19)
	at com.kim.service.impl.RentbuyServiceImpl.save(RentbuyServiceImpl.java:45)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	at com.sun.proxy.$Proxy17.save(Unknown Source)
	at com.kim.action.RentbuyAction.addRentbuy(RentbuyAction.java:54)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMet