insert into shop_info ( `id`, `shop_id`, `shop_name`, `shop_notice`, `shop_score`, `shop_service`, `org_name`, `org_id`, `org_introduction`, `add_by`, `add_name`, `add_time`, `last_edit_by`, `last_edit_name`, `last_edit_time`, `del_flag`, `online_service` ) values ( #{id}, #{shopId}, #{shopName}, #{shopNotice}, #{shopScore}, #{shopService}, #{orgName}, #{orgId}, #{orgIntroduction}, #{addBy}, #{addName}, #{addTime}, #{lastEditBy}, #{lastEditName}, #{lastEditTime}, #{delFlag}, #{onlineService} ) ON DUPLICATE KEY UPDATE `shop_name`= values(`shop_name`), `shop_notice` = values(`shop_notice`), `shop_score` = values(`shop_score`), `shop_service` = values(`shop_service`), `org_name` = values(`org_name`), `org_id` = values(`org_id`), `org_introduction` = values(`org_introduction`), `last_edit_by` = values(`last_edit_by`), `last_edit_name` = values(`last_edit_name`), `last_edit_time` = values(`last_edit_time`), `del_flag` = values(`del_flag`), `online_service` = values(`online_service`)
mybatis insertOrUpdate操作
最新推荐文章于 2024-08-06 09:09:50 发布