create table tbl_SMSendTask
(
ID INTEGER NOT NULL,
subtime TIMESTAMP,
orgaddr VARCHAR(128) NOT NULL,
destaddr VARCHAR(128) NOT NULL,
sm_content VARCHAR(128),
CONSTRAINT P_Key_1 PRIMARY KEY (ID)
)
CREATE SEQUENCE ETL_BUSI_TYPE_TOSEND_ID_SEQ
AS INT START WITH 1 INCREMENT BY 1 MINVALUE 1
NO MAXVALUE NO CYCLE NO CACHE ORDER ;
insert into ETL_BUSI_TYPE_TOSEND (BUSI_ID, CONTACT_ID,ID) values (?,?,NEXTVAL for ETL_BUSI_TYPE_TOSEND_ID_SEQ)
数据库语句(sequesce序列)
最新推荐文章于 2022-11-03 16:45:02 发布