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,);
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,);