2019-08-28:批量更新mysql
2019-08-28 本文已影响0人
AI_Finance
update algo_diagnosis_dataset2 as table1
inner join hmcdss2_lx_0705.mt_patient_disease as table2
on table1.uuid=table2.uuid
set table1.admissionDiagnosis=table2.disease_name
update algo_diagnosis_dataset2 as table1
inner join hmcdss2_lx_0705.mt_patient_disease as table2
on table1.uuid=table2.uuid
set table1.admissionDiagnosis=table2.disease_name