oracle mysql 数据库字段自增长

mysql 自增长
drop table if exists 'user1';
create table user1(id int not null auto_increment,
name varchar(30) not null,
password varchar(50) not null,
email varchar(50),
birthday date,
age int,
primary key(id));


insert into user1(name,password,email,birthday,age)
values();


oracle自增长
create table user1(
id number,
name varchar2(30),
passwd varchar2(50),
email varchar2(100),
birthday date, 
age number(3),
primary key(id)
);


--创建序列
create sequence user1_seq
start with 1
increment by 1
minvalue 1
nomaxvalue
nocache
nocycle;
insert into user1(id,name,password,email,birthday,age)
values(user1_seq.NEXTVAL,);