immersed-in-the-deep-sea

导航

 
clickhouse不支持事务
begin end这种没法用
<update id="updateEndTime" parameterType="java.util.Map">
BEGIN
<foreach collection="mergeMap.entrySet()" item="value" index="key" separator="">
UPDATE T_ALARM_INFO
SET
<if test="value!=null">
END_TIME = #{value}
</if>
WHERE ID = #{key};
</foreach>
END
</update>
改成
注意clickhouse中药换成小写

alter TABLE CLOUD_NETWORK_VISUAL.T_ALARM_INFO
update
end_time = '2025-07-31 09:37:00.000'
WHERE id = '123';

posted on 2025-08-01 17:10  沉浸深海  阅读(6)  评论(0)    收藏  举报