###mybatis批量保存信息,如果信息已经存在,则更新
数据唯一索引建立在authority_identifier,application_id,resource_names上,如果出现冲突就会更新字段
INSERT INTO `upms_resource`(line_no,id,create_time,update_time,version,resource_name,resource_type,authority_identifier,url,application_identifier,parent_resource_id,application_id) VALUES (null, 1151669296037425196,NOW(), NOW(), 0,'userList', 'BUTTON', 'open-api:user:lis','/auth/open-api/user/list' , 'finance-system', 1151669296037425154, 1) on duplicate key update resource_name=VALUES(resource_name),resource_type=VALUES(resource_type),url=VALUES(ur),parent_resource_id=VALUES(parent_resource_id);
crm_taobao_traderates是淘宝的店铺评论表,如果维护了数据库的唯一约束就会更新数据
<sql id="table_name">crm_taobao_traderates</sql>
<sql id="base_column">series,tid,oid,role,nick,result,taobao_created,rated_nick,item_titl