CREATE TABLE notice(
id int(4) NOT NULL auto_increment,
title varchar2(50),
body varchar2(500),
writer varchar2(10),
coname varchar2(50),
FbDate varchar2(50),
PRIMARY KEY (id)
); 大家看看我上面的语句对不对?我想让id是主建并自增长
id int(4) NOT NULL auto_increment,
title varchar2(50),
body varchar2(500),
writer varchar2(10),
coname varchar2(50),
FbDate varchar2(50),
PRIMARY KEY (id)
); 大家看看我上面的语句对不对?我想让id是主建并自增长
id int(4) NOT NULL,
title varchar2(50),
body varchar2(500),
writer varchar2(10),
coname varchar2(50),
FbDate varchar2(50),
PRIMARY KEY (id)
);
CREATE TABLE notice(
id int(4) NOT NULL auto_increment,
title varchar2(50),
body varchar2(500),
writer varchar2(10),
coname varchar2(50),
FbDate varchar2(50),
PRIMARY KEY (id)
); INSERT INTO notice VALUES
(empseq.nextval,其他字段);
INCREMENT BY 1 -- 每次加几个
START WITH 1 -- 从1开始计数
NOMAXVALUE -- 不设置最大值
NOCYCLE -- 一直累加,不循环
CACHE 10;
http://81.cnblogs.com/