1. <pg>
    2. <insert id="insertBean" parameterType="com.hikvision.idatafusion.modelcatalogcenter.business.base.bean.DataAnalysisTaskBean"
    3. useGeneratedKeys="true" keyProperty="id">
    4. insert into table
    5. (
    6. create_time, update_time, delete_falg
    7. )
    8. values
    9. (
    10. now(), now(), 1
    11. )
    12. ON CONFLICT(resource_model_code, ability_code) DO update set
    13. resource_type=EXCLUDED.resource_type,
    14. isvalid = 1,
    15. update_time = now()
    16. </insert>