KM项目更新SEQ的SQL

最新推荐文章于 2025-07-15 00:11:21 发布

最新推荐文章于 2025-07-15 00:11:21 发布 · 216 阅读

文章标签：

#SQL

本文介绍了一种通过查询最大ID值并加1的方式来更新数据库中特定序列的方法。涉及到多个表，如KM_BID、KM_BTYPE等，确保了每个表的序列值都能反映最新的ID状态。

Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_BID) Where s.sequence_name='KM_BID';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_BTYPE) Where s.sequence_name='KM_BTYPE';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_CHECK_GROUP) Where s.sequence_name='KM_CHECK_GROUP';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_KNOWLEDGE) Where s.sequence_name='KM_KNOWLEDGE';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_KNOWLEDGE_ATTACH) Where s.sequence_name='KM_KNOWLEDGE_ATTACH';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_PERSONALFAVOR) Where s.sequence_name='KM_PERSONALFAVOR';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_TN_KNOWLEDGE) Where s.sequence_name='KM_TN_KNOWLEDGE';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_TREE_NODE) Where s.sequence_name='KM_TREE_NODE';
Update sys_sequence s Set s.sequence_index=(Select Max(Id)+1 From KM_TREE_NODE_POWER) Where s.sequence_name='KM_TREE_NODE_POWER';