<p><br></p>
<p><span style="background-color:rgb(192,192,192);">### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'ID' in where clause is ambiguous<br>
### The error may exist in file [E:\1715\ssm-blog-admin\target\ssm-blog-admin\WEB-INF\classes\com\ssm\blog\dao\mapper\BlogMappper.xml]<br>
### The error may involve com.ssm.blog.dao.BlogDAO.getBlogList-Inline<br>
### The error occurred while setting parameters<br>
### SQL: SELECT count(0) FROM BLOG B INNER JOIN ADMIN_USER A ON B.USER_ID = A.ID LEFT JOIN CATEGORY C ON B.CATEGORY_ID = C.ID WHERE ID = ?<br>
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
<span style="color:#FF0000;">Column 'ID' in where clause is ambiguous</span><br>
; SQL []; <span style="color:#FF0000;">Column 'ID' in where clause is ambiguous;</span> nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'ID' in where clause is ambiguous<br>
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:85)</span><br><br>
意思是sql语句中ID这个字段有歧义,这种情况多出现在多表联查的时候,两个表中有同名的字段,比如ID,而查询的时候没有指定是哪张表的ID,下面的语句会报错。因为BLOG和ADMIN_USER表中都有ID,WHERE中的ID=?没有指明去查询谁的ID<br><br>
SELECT count(0) FROM BLOG B INNER JOIN ADMIN_USER A ON B.USER_ID = A.ID LEFT JOIN CATEGORY C ON B.CATEGORY_ID = C.ID WHERE ID = ?<br><br>
修改后:<br><br>
SELECT count(0) FROM BLOG B INNER JOIN ADMIN_USER A ON B.USER_ID = A.ID LEFT JOIN CATEGORY C ON B.CATEGORY_ID = C.ID WHERE
<span style="color:#FF0000;">B.</span>ID = ?<br><br><br></p>
<p><br></p>
<p><br></p>