FROM DUAL实现防止重复插入

INSERT INTO qrdish_store_collect (tenant_id,store_id,user_id)
        SELECT  #{tenantId},#{storeId},#{userId} FROM DUAL
        WHERE NOT EXISTS (
            SELECT  *
            FROM qrdish_store_collect
            WHERE user_id = #{userId}
            AND tenant_id = #{tenantId}
            AND store_id = #{storeId}
            AND delete_flag = 0
        )