【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供008_create_user.sql参考,解决您在008_create_user.sql学习中工作中的难题,参考学习。
CREATE TABLE T_USER(
ID BIGINT,
NAME VARCHAR(50),
PASSWORD VARCHAR(50),
CREATE_DATE DATETIME
);
ALTER TABLE T_USER ADD CONSTRAINT PK_USER PRIMARY KEY(ID);
ALTER TABLE T_USER ALTER COLUMN ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1);
INSERT INTO T_USER(ID,NAME,PASSWORD,CREATE_DATE) VALUES(3,'admin','123456','2009-9-13 0:11:33');
INSERT INTO T_USER(ID,NAME,PASSWORD,CREATE_DATE) VALUES(9,'张三','123456','2009-9-17 19:07:35');
INSERT INTO T_USER(ID,NAME,PASSWORD,CREATE_DATE) VALUES(10,'李四','123456','2009-9-17 22:25:46');
--//@UNDO
DROP TABLE T_USER;