创建自增列[id]为主键数据表
–1、创建表
create table performanceStatistics(
id number(10) primary key, /主键,自动增加/
uuid varchar(50) NOT NULL,
place varchar(50) NOT NULL,
timestamp varchar(100) NOT NULL,
standard varchar(100),
whether varchar(100)
);
–2、创建序列
CREATE SEQUENCE Satisfaction_Sequence
INCREMENT BY 1 – 每次加几个
START WITH 1 – 从1开始计数
NOMAXVALUE – 不设置最大值
NOCYCLE – 一直累加,不循环
CACHE 10;
–3、创建触发器
CREATE TRIGGER satisfaction
BEFORE INSERT
ON performanceStatistics
FOR EACH ROW
BEGIN
SELECT Satisfaction_Sequence.NEXTVAL
INTO :New.id
FROM dual;
END;
—4、测试 插入、查询、删除
插入
insert into performanceStatistics(Uuid,Place,Timestamp) values(‘16630114021’,‘api’,‘20210719’)
查询、
select * from performanceStatistics p
select count(*) from performanceStatistics
删除
delete from performanceStatistics