duanmengsuo9302 2019-05-16 08:50
浏览 686
已采纳

在一个Postgresql中更新多个表

I have three tables A, B, C. Table B & Table C consist foreign key from table A's id.

When updating Form, data will be updated to these three tables by identifying the foreign key.

CREATE TABLE A(
   id serial PRIMARY KEY, 
   id_theme_thesaurus  text,
   id_series text,
   id_geo_form text
);

CREATE  TABLE B(
   id  serial PRIMARY KEY,
   meta_id int,
   cit_title text,
   cit_pub_date text
);

CREATE  TABLE C(
   id serial PRIMARY KEY,
   meta_id int,
   id_originator text
);

And here is my update statement

UPDATE B AS c
SET cit_pub_date = '2016'
FROM t_metadata AS m
WHERE c.meta_id = m.id
AND m.id = '2';

UPDATE C AS o
SET id_originator = 'UN'
FROM t_metadata AS m
WHERE o.meta_id = m.id
AND m.id = '2';

How can I join these two UPDATE statements to become one in the join?

  • 写回答

1条回答

      报告相同问题?

      相关推荐 更多相似问题

      悬赏问题

      • ¥15 内存管理的一段代码不是很理解
      • ¥20 打开anaconda时卡在Loading applications无法进入界面
      • ¥15 网页超时时间设置失效
      • ¥15 有关绿色信贷毕业论文的问题
      • ¥30 关于#机器人#的问题,如何解决?
      • ¥15 求MATLAB函数ScalarLayerDisplay的代码
      • ¥15 安卓如何自动执行检测到的NFC标签,无需再点确认
      • ¥15 pyHM库mouse模块的ValueError错误
      • ¥15 python opencv 摄像头 传感器
      • ¥30 eMMC&Android&C&Linux