insert ETL_0730_ZY_WXS.`yd_patient_11_basic_info`(
uuid,
patient_guid,
patient_name,
patient_gender,
patient_age,
patient_age_type,
inpatient_department,
doctor_name,
admission_date,
discharge_date,
diagnose_source_name,
profile_part_type,
profile_part_name,
first_diagnose_disease_id,
first_diagnose_disease_name,
disease_class_id,
disease_class_name,
diagnose_class_name,
belonged_category
)
select uuid, patient_guid, patient_name, patient_gender, patient_age, patient_age_type, admission_dept_name, doctor_name,
admission_time, discharge_time, NULL, NULL, NULL, NULL, NULL, NULL, "小儿肺炎", NULL, NULL
from mid_patient_info_t
where (first_diagnosis_list like "%社区获得性肺炎%" or first_diagnosis_list like "%支气管肺炎%") and patient_age<18;
网友评论