【DM版本】:DM Database Server 64 V8 【操作系统】：中标麒麟 【CPU】:Intel® Xeon® Silver 4210 CPU @ 2.20GHz 【问题描述】*：达梦如何实现update，并返回更新后的信息 比如这样 update train set organize_unit=‘AAA’ where uuid=‘09df6410-a19b-11eb-973b-5fe9484862a2’ returning *;
CREATE TABLE T1(C1 INT,C2 INT,C3 INT); INSERT INTO T1 VALUES(1,2,2); INSERT INTO T1 VALUES(1,2,3); COMMIT;
DECLARE A INT; BEGIN UPDATE T1 SET C2=5 WHERE C3 = 2 RETURN C2 INTO A; PRINT A; END;
RETURNING也可以
CREATE TABLE T1(C1 INT,C2 INT,C3 INT);
INSERT INTO T1 VALUES(1,2,2);
INSERT INTO T1 VALUES(1,2,3);
COMMIT;
DECLARE
A INT;
BEGIN
UPDATE T1 SET C2=5 WHERE C3 = 2 RETURN C2 INTO A;
PRINT A;
END;