创建库
创建库之前可以先创建一个管理用户
用新建的管理用户账号再次登录
新建一个模式<库>方式
语句创建模式<库>
CREATE SCHEMA “<名称>” AUTHORIZATION “<拥有者>”;
如:
CREATE SCHEMA “TESTDEMO” AUTHORIZATION “CNLENNON”;
建表方式
语句创建表
CREATE TABLE “TESTDEMO”.“demo_1”
(
“ID” VARCHAR(50) NOT NULL,
“Name” VARCHAR(50),
“Ctreate_time” DATETIME(6),
CLUSTER PRIMARY KEY(“ID”)) STORAGE(ON “MAIN”, CLUSTERBTR) ;
COMMENT ON COLUMN “CNLENNON”.“demo_1”.“ID” IS ‘主键’;
COMMENT ON COLUMN “CNLENNON”.“demo_1”.“Name” IS ‘名称’;
COMMENT ON COLUMN “CNLENNON”.“demo_1”.“Ctreate_time” IS ‘创建事件’;
查询语句
select “ID”,“Name”,“Ctreate_time”
from “<库名>”."<表名>";
如:
select “ID”,“Name”,“Ctreate_time”
from “TESTDEMO”.“demo_1”;
//插入数据语句
insert into “TEST”.“demo_1”(“ID”, “Name”, “Ctreate_time”)
VALUES(‘1’, ‘名称2’, ‘2021-04-21 10:10:45’);
//更新语句–更新某一行中的若干列
update “TESTDEMO”.“demo_1”
set “Name” = ‘名称12’, “Ctreate_time” = ‘2021-10-10 12-10-30’ WHERE “ID” =‘2’;
//删除语句
delete from “TESTDEMO”.“demo_1” where Id=‘1’;
另附:
达梦学习手册