DBMaster是否支持在子查询中对目标表进行UPDATE/INSERT/DELETE?(DBMR: 1913)

~ 0 min
2016-02-25 07:44

目前,DBMaster不支持在子查询中对目标表进行UPDATE/INSERT/DELETE操作,不过用户可以通过临时表来替换目标表。

例如:

dmSQL> INSERT INTO uselgcsvcs

SELECT host_id, service_name, MAX(specification) as specification FROM usesvcs T WHERE NOT EXISTS (SELECT service_name FROM uselgcsvcs L WHERE T.host_id = L.host_id and T.service_name = L.service_name) GROUP BY host_id, service_name;

ERROR (6172): [DBMaster] cannot select into a table which has already been referenced in the query

平均分: 0 (0 投票)

你不能对该内容发表评论

标签