ALTER table chf_patients add gender char(1); --向cchf_patients 新增一列 gender
只有先增加一列之后,才能向该列更新值。默认值为NULL。
UPDATE chf_patients
SET gender = aa.gender --把aa表中的gender按照subject_id对应更新
FROM (
SELECT chf.subject_id,patients.gender
FROM chf_patients as chf INNER JOIN patients on chf.subject_id=patients.subject_id
)as aa
WHERE chf_patients.subject_id=aa.subject_id