1.创建表
CREATE TABLE items (
id number(11) NOT NULL ,
name varchar(32) NOT NULL,
price float NOT NULL,
detail clob ,
pic varchar(64),
createtime date ,
PRIMARY KEY (id)
)
2.创建序列
create sequence items_idautoinc
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
nocache;
3.添加数据
insert into items(id,name,price,detail,pic,createtime) values (items_idautoinc.nextval,'笔记本',6000.0,'笔记本性能好,质量好!!!!!',NULL,to_date( '2018-02-01', 'yyyy-MM-dd'))
4.效果图
5.第二种方法就是建立一个触发器,在往表里插入数据时id自动加一
CREATE OR REPLACE TRIGGER "insert_items_idautoinc"
BEFORE INSERT ON items
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
DECLARE
BEGIN
SELECT items_idautoinc.NEXTVAL INTO :NEW.ID FROM DUAL;
END insert_items_idautoinc;
插入一条数据,没有id和值
insert into items(name,price,detail,pic,createtime) values ('笔记本1',6000.0,'笔记本性能好,质量好!!!!!',NULL,to_date( '2018-02-01', 'yyyy-MM-dd'))
效果图