2019-08-08

从mid_patient_info_t插入到公共基础表

insert indicator_statistics.`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 
)
select uuid, patient_guid, patient_name, patient_gender, patient_age, patient_age_type, admission_dept_name, doctor_name,
       admission_date, discharge_date, NULL, NULL, NULL, NULL, NULL, NULL, NULL, disease_name 
from mid_patient_info_t
where disease_name like "%肺炎%" and patient_age<18