MySQLIntegrityConstraintViolationException: Column 'relation' in where clause is ambiguous

最新推荐文章于 2024-06-25 11:24:14 发布

流浪的神明吗

最新推荐文章于 2024-06-25 11:24:14 发布

阅读量967

点赞数 2

分类专栏：错误积累文章标签： mysql

本文链接：https://blog.csdn.net/u010173095/article/details/79925770

版权

错误积累专栏收录该内容

35 篇文章 0 订阅

订阅专栏

今天项目执行sql 的时候，报了这个错误：

ause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'relation' in where clause is ambiguous
; SQL []; Column 'relation' in where clause is ambiguous; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'relation' in where clause is ambiguous
    at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:85) ~[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) ~[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) ~[spring-jdbc-4.2.5.RELEASE.jar:4.2.5.RELEASE]
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74) ~[mybatis-spring-1.2.3.jar:1.2.3]