MySQL 两张表关联更新 用一张表的数据更新另一张表的数据
mysql更新语句
UPDATE ars_room A JOIN ars_room_copy1 B
ON A.room_id=B.room_id
SET A.room_name=B.room_name,A.hospital_id=B.hospital_id
WHERE A.room_id='2'
Postgres更新语句
UPDATE call_mz_queue_temporary aa
SET medical_card=bb.out_pat_code
FROM bbb bb
WHERE aa.out_pat_id=bb.out_pat_id AND aa.mz_queue_id BETWEEN '3298' AND '3460'