【SQL开源代码栏目提醒】:网学会员--在 SQL开源代码编辑为广大网友搜集整理了:002_create_news.sql绩等信息,祝愿广大网友取得需要的信息,参考学习。
CREATE TABLE T_NEWS(
ID BIGINT,
TITLE VARCHAR(200),
CONTENT VARCHAR(4000),
CREATE_TIME DATETIME
);
ALTER TABLE T_NEWS ADD CONSTRAINT PK_NEWS PRIMARY KEY(ID);
ALTER TABLE T_NEWS ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
INSERT INTO T_NEWS(ID,TITLE,CONTENT,CREATE_TIME)
VALUES(1,'优惠信息一','所有手提电脑折扣8折','2009-09-02 01:45:20.813');
INSERT INTO T_NEWS(ID,TITLE,CONTENT,CREATE_TIME)
VALUES(2,'优惠信息二','所有pc折扣85折','2009-09-02 01:45:34.453');
--//@UNDO
DROP TABLE T_NEWS;