Update Select批量更新

最新推荐文章于 2023-07-26 10:46:06 发布

kanlianhui

最新推荐文章于 2023-07-26 10:46:06 发布

阅读量3.4w

点赞数

分类专栏： Oracle 文章标签： insert table null

本文链接：https://blog.csdn.net/kanlianhui/article/details/7078335

版权

Oracle 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

CREATE TABLE dualx(
       x_id VARCHAR(5) NOT NULL ,
       x_con VARCHAR(10)
)

CREATE TABLE dualy(
       y_id VARCHAR(5) NOT NULL ,
       y_con VARCHAR(10)
)

INSERT INTO dualx VALUES ('1','xxx');
INSERT INTO dualx VALUES ('2','xxx');
INSERT INTO dualx VALUES ('3','xxx');

INSERT INTO dualy VALUES ('1','111');
INSERT INTO dualy VALUES ('2','222');
INSERT INTO dualy VALUES ('3','333');

UPDATE dualx   SET (x_con) = (SELECT y.y_con  FROM  dualy y WHERE dualx.x_id = y.y_id)

SELECT * FROM dualx;
SELECT * FROM dualy;
DROP TABLE dualx;
DROP TABLE dualy;

UPDATE dualx SET (x_con) = (SELECT y.y_con FROM dualy y WHERE dualx.x_id = y.y_id) 其中SELECT y.y_con FROM dualy y WHERE dualx.x_id = y.y_id不能返回多行，否则报错。