mybatis的foreach---mysql

mybatis的foreach—mysql

----传参：list
 <insert id="in
	  insert into mytable
	  a,b,c
	  values
	  <foreach collection="monthList" item="item" separator=",">
	   (#{item.a},#{item.b},#{item.c},)
	  </foreach>
  </insert>
  
 <update id="updateDayData">
        <foreach collection="dayListUp" item="item" separator=";">
          update invoking_statistics_day
                set
                all_statistics = #{item.a},
                succeed_statistics =#{item.b}
          </foreach>
  </update>

----传参：字符串逗号分隔
    <foreach collection="ids" item="id" open ="(" separator="," close=")" >
                #{id}
     </foreach>