MySql语法报错org.springframework.jdbc.BadSqlGrammarException:

Question

<update id="updateCustomerStateByIds" >
    update
         t_customer
    set
         state = 1
    where
         id
    in
    <foreach collection="list" item="item" open="(" close=")" separator=",">
      #{item}
    </foreach>
  </update>

Answer 1

不都打印出来了，SQL语法错误，list为空导致 in 后面没有 （）