我的表:CREATE TABLE users (
idint NOT NULL ,
name varchar(50) NOT NULL ,
password varchar(50) NOT NULL ,
email varchar(50) NOT NULL ,
isOnline int DEFAULT '0' NOT NULL ,
imgint DEFAULT '0',
time varchar(50) NOT NULL,
PRIMARY KEY (id,email)
)
1. 首先创建触发器,代码如下
create or replace trigger tr_users
before insert onusers
for each row
declare
-- local variables here
begin
select users_seq.nextval into :new.id from dual;
end tr_users;
2. 创建序列
代码如下:
-- Create sequence
create sequence USERS_SEQ
minvalue 1
maxvalue 9999999999999999999999999999
start with 21
increment by 1
cache 20;
测试数据:
Insert into users(name,password,email,isonline,img,time)values('xia','123','123@qq.com',0,0,'8:22');
效果图: