--自增长序列 create table test( tid int not null, tname varchar(20), tsex varchar(20), tbz varchar(50) ) --添加主键约束 alter table test add constraint test_pk primary key (tid) --自增序列 create sequence test_seq minvalue 1 maxvalue 1000 start with 1 increment by 1 --插入数据 insert into test values(test_seq.nextval,'张三','男','无备注'); insert into test values(test_seq.nextval,'李四','男','组长');