【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供002_create_in.sql参考,解决您在002_create_in.sql学习中工作中的难题,参考学习。
CREATE TABLE T_IN(
ID BIGINT,
CREATE_TIME DATETIME,
OPERATOR VARCHAR(50),
TOTAL DOUBLE
);
ALTER TABLE T_IN ADD CONSTRAINT PK_IN PRIMARY KEY(ID);
ALTER TABLE T_IN ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
INSERT INTO T_IN(ID,CREATE_TIME,OPERATOR,TOTAL) VALUES(5,'2009-9-17 0:00:00','张三',64000);
INSERT INTO T_IN(ID,CREATE_TIME,OPERATOR,TOTAL) VALUES(6,'2009-9-17 0:00:00','张三',16000);
--//@UNDO
DROP TABLE T_IN;