【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-001_create_user.sql,希望本篇文章对您学习有所帮助。
CREATE TABLE T_USER(
ID BIGINT,
USERNAME VARCHAR(200),
PASSWORD VARCHAR(128),
REALNAME VARCHAR(200),
ADDRESS VARCHAR(500),
EMAIL VARCHAR(100),
PHONE VARCHAR(100),
DESCRIPTION VARCHAR(800)
);
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,USERNAME,PASSWORD,REALNAME,ADDRESS,EMAIL,PHONE)
VALUES(1,'huang','123456','黄灯桥','佛山','tianxiaode@hotmail.com','131');
INSERT INTO T_USER(ID,USERNAME,PASSWORD,REALNAME,ADDRESS,EMAIL,PHONE)
VALUES(2,'lingo','123456','徐会生','北京','xyz20003@gmail.com','141');
INSERT INTO T_USER(ID,USERNAME,PASSWORD,REALNAME,ADDRESS,EMAIL,PHONE)
VALUES(11,'test','123','test','test','test@123.net','test');
--//@UNDO
DROP TABLE T_USER;