2021-08-10

批量新增
因为项目sql的xml不支持foreach属性

insert into rp_prizes (user_name, id_card, phone, code,del_falg,create_date)
values

(#{item.userName}, #{item.idCard}, #{item.phone}, #{item.code},#{item.delFalg},#{item.createDate})

ON DUPLICATE KEY UPDATE user_name = VALUES(user_name),id_card = VALUES(id_card)

记录一下mysql的批量导入

INSERT INTO TEST(
NAME,
PASSWORD ,
LAST_UPDATE_TMS,
CREATEDATE,
)
VALUES (

#list[].name:VARCHAR# ,
#list[].password:VARCHAR# ,
NOW() ,
NOW()