批量插入

  1. insert into TB_DS_FAULT_MODIFY_COLUMN
  2. (ID,MODIFY_ID,MODIFY_COLUMN,MODIFY_COLUMN_NAME,OLD_VALUE,NEW_VALUE)
  3. values
  4. <foreach collection="list" item="item" index="index" separator=",">
  5. (#{item.id},
  6. #{item.modifyId},
  7. #{item.modifyColumn},
  8. #{item.modifyColumnName},
  9. #{item.oldValue},
  10. #{item.newValue}
  11. )
  12. </foreach>