excel表格数据对数据库处理

增加数据： 

insert into t_kd_cust_map (kd_cust_code, kd_cust_name, kd_cust_addr, customer_id, supplier_id)
select '1' as supplier_id union
select '1' as supplier_id union
select '1' as supplier_id union

 

更新数据 ：（替换原先存在的数据） 

update t_kd_goods_map m set kd_goods_code = n.new_code,update_time = now() from (
    select kgm.id ,t.new_code from t_kd_goods_map kgm
    left join (
        select '07.02.0193' as old_code,'*纸制箱=8包' as old_name,'01.01.0040' as new_code,'*纸制=8包' as new_name union
        select '07.02.0207' as old_code,'100g电子礼花（80cm）' as old_name,'01.01.0041' as new_code,'100g电子礼花（80cm）' as new_name union
        select '07.02.0213' as old_code,'*纸制品' as old_name,'01.01.0042' as new_code,'*纸制品' as new_name
    ) t on kgm.kd_goods_code = t.old_code and kgm.status = 1
    where t.old_code notnull
) n where m.id = n.id;