1.openGauss DDL语句

/*创建数据库*/
create database myschool;

/*创建序列*/
SET search_path = public;
CREATE SEQUENCE sq_users_id
 START 1 
 INCREMENT 1
 CACHE 20; 

/*创建用户表*/ 
SET search_path = public;
CREATE  TABLE "users" (
    uid integer NOT NULL DEFAULT nextval('sq_users_id') PRIMARY KEY,
    username character varying,
    password character varying
)
WITH (orientation=row, compression=no);
COMMENT ON COLUMN "users".uid IS '用户ID';
COMMENT ON COLUMN "users".username IS '用户名';
COMMENT ON COLUMN "users".password IS '密码';
ALTER TABLE "users" ADD CONSTRAINT users_id_key UNIQUE (uid);

/*插入用户记录*/
insert into users (username,password) values ('admin','123456'),('张三','123456'),('李四','123456'),('王五','123456');

/*查询用户表*/
select * from users;

/*删除用户表*/
drop table users;

/*删除数据库*/
drop database myschool;