Mybatis XML数据查询foreach list 循环出来的结果报如下错误

Question

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '0613b2f5fd1542f7a0733371e490cbc8' in 'where clause'

and a.order_tab_id in

${orderId}

Answer 1

sql语法错误，你可以在控制台或者日志文件，找到打印的sql.