美文网首页
2019-08-15:插入basic_info

2019-08-15:插入basic_info

作者: AI_Finance | 来源:发表于2019-08-15 23:06 被阅读0次
    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;
    

    相关文章

      网友评论

          本文标题:2019-08-15:插入basic_info

          本文链接:https://www.haomeiwen.com/subject/hocxsctx.html