Mysql迁移到highgoDB如何实现ID自增长
source link: https://my.oschina.net/u/4908520/blog/4893838
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Mysql数据库迁移到HighGo数据库后,原Mysql表中自增长的ID如何保持自增长?
分两种情况进行处理,具体如下:
(1)数据库中已经存在表(tab1),而且已经有数据,而且不想改动其他,只想改成自增,步骤如下
①譬如先创建序列:CREATE SEQUENCE public.tab1_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 最后一行数+1 --如果表中有数据,开始值应该是数据表最后一行加1
CACHE 1;
②再把序列和表建立关系:
ALTER TABLE tab1 ALTER COLUMN id SET DEFAULT nextval('tab1_id_seq'::regclass)
注意:HighGo DB默认情况下,建立的序列最大值可以是: 9223372036854775807,超过此值将是无效的。这一点与oracle是有区别的,oracle的最大值是:999999999999999999999999999
更多详细信息请登录【瀚高技术支持平台】查看https://support.highgo.com/#/index/docContentHighgo/870d479b05851671
© 著作权归作者所有
其他人还在看
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK