CREATE SET TABLE dwPDATA.aa_fan ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
cc INTEGER GENERATED ALWAYS AS IDENTITY
(START WITH 5
INCREMENT BY 2
MINVALUE -2147483647
MAXVALUE 2147483647
NO CYCLE),
aa CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( cc );
插入测试值：
insert into dwpdata.aa_fan values('','g')；
insert into dwpdata.aa_fan values('','3')；
insert into dwpdata.aa_fan values('','d')；
查看表中数据，cc字段根据设定好的方式自动插入：
sel * from dwpdata.aa_fan;
5 g
9 d
7 3
匿名回答于2024-05-28 15:18:25
