mysql db中数据存在就更新,不存在就插入

发布时间 2023-06-30 17:38:22作者: 苹果芒
     insert into result(projectId,year,month,apiCoverageRate,codeCoverageRate,autoTestCaseFinishRate,testCaseFinishRate,createTime,modifyTime)
     values(
     #{projectId},#{year},#{month},#{apiCoverageRate},#{codeCoverageRate},#{autoTestCaseFinishRate},#{testCaseFinishRate},#{createTime},#{modifyTime}
     )
     on duplicate key update
      apiCoverageRate=#{apiCoverageRate},
      codeCoverageRate=#{codeCoverageRate},
      autoTestCaseFinishRate=#{autoTestCaseFinishRate},
      testCaseFinishRate=#{testCaseFinishRate},
      modifyTime=#{modifyTime}