1 创建表
/*第一步:创建表格*/
create table t_user(
id int primary key, --主键,自增长
username varchar(20),
password varchar(20),
type varchar(20)
);
2 创建自增序列信息
/*第二步:建立自定义的sequence*/
CREATE SEQUENCE user_sequence
increment by 1 -- 每次加几个
start with 1 -- 从1开始计数
nomaxvalue -- 不设置最大值
nocycle -- 一直累加,不循环
nocache -- 不建缓冲区
3 建立触发器
/*第三步:建立触发器*/
create trigger mem_trig before
insert on t_user for each row when (new.id is null)
begin
select user_sequence.nextval into:new.id from dual;
end;
4 添加数据
/*第四步:插入数据*/
insert into t_user values(null,'aaa','aaa','admin');
insert into t_user values(null,'bbb','bbb','user');
insert into t_user values(null,'ccc','ccc','admin');
insert into t_user values(null,'ddd','ddd','user');
获取插入的自增id
select reg_form.currval from dual
标签:insert,自增,into,主键,user,oracle,null,id
来源: https://www.cnblogs.com/houweijian/p/12061152.html