南大通用GBase 8a多表关联删除delete join

GBase 8a数据库集群支持对一张表,关联删除。其语法和update类似。

参考

GBase 8a数据库多表关联更新update

语法

delete T from AA T inner join BB T2 on T.id=T2.id

样例

gbase> create table t2(id int);
Query OK, 0 rows affected (Elapsed: 00:00:00.29)

gbase>
gbase>
gbase>
gbase> insert into t2 values(1);
Query OK, 1 row affected (Elapsed: 00:00:00.16)

gbase> delete t2 from t2 inner join t1 on t1.id=t2.id;
Query OK, 1 row affected (Elapsed: 00:00:00.17)