load文件加载大量数据--性能优化

马小跳在飞

于 2024-07-20 15:35:43 发布

阅读量233

点赞数 1

文章标签： mysql

本文链接：https://blog.csdn.net/weixin_33207551/article/details/140572291

版权

存在就更新

不存在就添加

LOAD DATA LOCAL INFILE 'D:/E/hrdata/salary/loaddata/csv/WaPersonItemConst_1116013123501301760_1264241220608065536.csv' REPLACE INTO TABLE wa_person_item_const fields terminated by ',' enclosed by '"' lines terminated by ' ' ignore 1 lines (id, @create_by, @create_time, @lastmodified_by, @lastmodified_time, @pay_grant_id, @wa_person_id, @payroll_item_id, @item_value, @vformula_proc, @amount_money, @is_pay, @year_period,@vformula, @vformula_desc, @org_id, @cyear, @cperiod, @pay_count, @is_maintain, @calc_after_update, @memo) SET create_by=@create_by, create_time=@create_time, lastmodified_by=@lastmodified_by, lastmodified_time=@lastmodified_time, pay_grant_id=@pay_grant_id, wa_person_id=@wa_person_id, payroll_item_id=@payroll_item_id, item_value=NULLIF(@item_value, 0), vformula_proc=NULLIF(@vformula_proc, ''), amount_money=@amount_money, is_pay=@is_pay, year_period=@year_period, vformula=NULLIF(@vformula, ''), vformula_desc=NULLIF(@vformula_desc, ''), org_id=NULLIF(@org_id, -1), cyear=NULLIF(@cyear, ''), cperiod=NULLIF(@cperiod, ''), pay_count=NULLIF(@pay_count, -1), is_maintain=@is_maintain, calc_after_update=@calc_after_update, memo=NULLIF(@memo, '')