tomcat 报Column 'del_flag' in where clause is ambiguous

2019独角兽企业重金招聘Python工程师标准>>>

错误提示：tomcat 控制台报Column 'del_flag' in where clause is ambiguous; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'del_flag' in where clause is ambiguous

解决方法：查询分析器分不清del_flag是哪个表的， 请在where条件当中明确条件，例如如果del_flag是别名为a表的字段 写成 a.del_flag即可

转载于:https://my.oschina.net/ferchen/blog/1492718