Mysql存储过程 -- 增加检测记录_mysql存储过程检查每条记录-优快云博客

本文链接：https://blog.youkuaiyun.com/Pei_hua100/article/details/108146248

DROP PROCEDURE if EXISTS SP_CREARTE_RESULT_2020;
CREATE PROCEDURE SP_CREARTE_RESULT_2020()
BEGIN
   DECLARE result_id INT;
   DECLARE create_date datetime;
   DECLARE count INT;

   SET create_date = now();
   SET count = 0;

   WHILE count < 100000 DO
       SET create_date = DATE_SUB(create_date,INTERVAL 1 DAY);
       INSERT INTO scc_medical_result20200811 (patient_id, surveyor_id, create_time, update_time, test_time, status, remark, diagram_data, result_status, customer_id, customer_code, intervene_flag, height_result, weight_result, sex, age, food_status, read_status, coordinate, area_id, remark_photo, legacy_data_flag, send_sms, device_bind_id, data_source, sample_no, apply_id, lot_number, ext_result_id, specimen, specimens, med_record_no, send_checker, review_person, beds, update_user_id, update_user_name, A001, B001, A002, B002, A003, B003, A004, B004, A005, B005, A006, B006, A007, B007, A008, B008, A009, B009, A010, B010, A011, B011, A012, B012, A013, B013, A014, B014, A015, B015, A016, B016, A017, B017, A018, B018, A019, B019, A020, B020, A021, B021, A022, B022, A023, B023, A024, B024, A025, B025, A026, B026, A027, B027, A028, B028, A029, B029, A030, B030, A031, B031, A032, B032, A033, B033, A034, B034, A035, B035, A036, B036, A037, B037, A038, B038, A039, B039, A040, B040, A041, B041, A042, B042, A043, B043, A044, B044, A045, B045, A046, B046, A047, B047, A048, B048, A049, B049, A050, B050, A051, B051, A052, B052, A053, B053, A054, B054, A055, B055, A056, B056, A057, B057, A058, B058, A059, B059, A060, B060, A061, B061, A062, B062, A063, B063, A064, B064, A065, B065, A066, B066, A067, B067, A068, B068, A069, B069, A070, B070, A071, B071, A072, B072, A073, B073, A074, B074, A075, B075, A076, B076, A077, B077, A078, B078, A079, B079, A080, B080, A081, B081, A082, B082, A083, B083, A084, B084, A085, B085, A086, B086, A087, B087, A088, B088, A089, B089, A090, B090, A091, B091, A092, B092, A093, B093, A094, B094, A095, B095, A096, B096, A097, B097, A098, B098, A099, B099, A100, B100, A101, B101, A102, B102, A103, B103, A104, B104, A105, B105, A106, B106, A107, B107, A108, B108, A109, B109, A110, B110) VALUES ('3060822', '589915047', create_date, NULL, create_date, '1', 'yph', NULL, '0', '111133745', '100100506', '0', NULL, NULL, '2', '113', NULL, '1', NULL, NULL, NULL, '0', '0', '0', '0', '', '0', NULL, '0', '0', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '145', '4', '100', '5', NULL, NULL, '90', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '145/100', '5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
       SET result_id = LAST_INSERT_ID();
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060822', NULL, NULL, '45', result_id, NULL, '145', '0', '1', '11', '90-139', '4', 'mmHg', '0', '0', '听诊法', '0', '', '', NULL, NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060822', '598', '1', '105', result_id, '根据您的检测结果分析如下：\n脉率正常值：60-100次/分钟\n您的脉搏频率属于正常，请继续保持。', '90', '0', '1', '14', '60-100', '3', '次/分钟', '0', '0', '--', '2', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060822', NULL, NULL, '114', result_id, NULL, '100', '0', '1', '12', '60-89', '5', 'mmHg', '0', '0', '听诊法', '0', '', '', NULL, NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060822', '460', '1', '133', result_id, '根据您的检测结果分析如下：\n血压正常值：90-119/60-79mmHg\n您的血压值属于中度高血压，建议您在初诊高血压后，进行全面的心血管风险的评估，对于中危患者来说，可以进行一段时间血压监测及危险因素观察后，再决定是否以及何时开始药物治疗；对于高危或很高危患者来说，一旦确诊，应立即开始对高血压及并存的危险因素和临床情况进行综合治疗。', '145/100', '0', '1', '19', '90-139/60-89', '5', 'mmHg', '0', '0', '听诊法', '2', '', '', '0', NULL);

       SET create_date = DATE_SUB(create_date,INTERVAL 1 DAY);
       INSERT INTO scc_medical_result20200811 (patient_id, surveyor_id, create_time, update_time, test_time, status, remark, diagram_data, result_status, customer_id, customer_code, intervene_flag, height_result, weight_result, sex, age, food_status, read_status, coordinate, area_id, remark_photo, legacy_data_flag, send_sms, device_bind_id, data_source, sample_no, apply_id, lot_number, ext_result_id, specimen, specimens, med_record_no, send_checker, review_person, beds, update_user_id, update_user_name, A001, B001, A002, B002, A003, B003, A004, B004, A005, B005, A006, B006, A007, B007, A008, B008, A009, B009, A010, B010, A011, B011, A012, B012, A013, B013, A014, B014, A015, B015, A016, B016, A017, B017, A018, B018, A019, B019, A020, B020, A021, B021, A022, B022, A023, B023, A024, B024, A025, B025, A026, B026, A027, B027, A028, B028, A029, B029, A030, B030, A031, B031, A032, B032, A033, B033, A034, B034, A035, B035, A036, B036, A037, B037, A038, B038, A039, B039, A040, B040, A041, B041, A042, B042, A043, B043, A044, B044, A045, B045, A046, B046, A047, B047, A048, B048, A049, B049, A050, B050, A051, B051, A052, B052, A053, B053, A054, B054, A055, B055, A056, B056, A057, B057, A058, B058, A059, B059, A060, B060, A061, B061, A062, B062, A063, B063, A064, B064, A065, B065, A066, B066, A067, B067, A068, B068, A069, B069, A070, B070, A071, B071, A072, B072, A073, B073, A074, B074, A075, B075, A076, B076, A077, B077, A078, B078, A079, B079, A080, B080, A081, B081, A082, B082, A083, B083, A084, B084, A085, B085, A086, B086, A087, B087, A088, B088, A089, B089, A090, B090, A091, B091, A092, B092, A093, B093, A094, B094, A095, B095, A096, B096, A097, B097, A098, B098, A099, B099, A100, B100, A101, B101, A102, B102, A103, B103, A104, B104, A105, B105, A106, B106, A107, B107, A108, B108, A109, B109, A110, B110) VALUES ('3060820', '561781524', create_date, NULL, create_date, '1', 'yph', NULL, '0', '111134139', '100600145151', '0', NULL, NULL, '1', '35', '3', '1', NULL, NULL, NULL, '0', '1', '0', '0', '', '0', NULL, '0', '0', NULL, '', '', '', '', NULL, NULL, NULL, NULL, '6.1', '3', NULL, NULL, '427', '4', '1.00', '2', '3.32', '3', '3.26', '6', '5.81', '4', '5.8', '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4.82', '5', '3.34', '5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
       SET result_id = LAST_INSERT_ID();
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '579', '1', '19', result_id, '根据您的检测结果分析如下：\n高密度脂蛋白胆固醇正常值：1.04-1.54mmol/L\n您的检测值属于降低，建议您首先采用改善生活方式的措施，包括戒烟、减轻体重、增加不饱和脂肪酸摄人、规律运动以及适量饮酒，以达到升高HDL-C的目标。', '1.00', '0', '1', '5', '1.04-1.54', '2', 'mmol/L', '0', '0', '光化学', '1', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '501', '1', '99', result_id, '根据您的检测结果分析如下：\n①非糖尿病随机血糖正常值在3.90-11.1mmol/L之间，\n②糖尿病随机血糖正常值应控制在4.40-11.1mmol/L之间；\n非糖尿病者：您的血糖是正常的，请您继续保持良好的生活方式，坚持体育锻炼，预防或控制肥胖，保持膳食平衡，戒烟戒酒。\n糖尿病患者：您的血糖控制很好，保持良好的血糖、血脂、血压水平，就可以有效地控制住糖尿病，预防并发症的发生，请继续保持！', '6.1', '0', '1', '2', '3.9-11.1', '3', 'mmol/L', '0', '3', '电化学', '1', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '566', '1', '28', result_id, '根据您的检测结果分析如下：\n甘油三酯正常值：＜1.76mmol/L\n您的检测值属于偏高，调查资料表明，血清TG水平轻至中度升高者，其患冠心病危险性增加，当 TG 重度升高时，常可伴发急性胰腺炎，建议您加强生活方式干预，必要时，在医生指导下进行药物治疗。', '3.26', '0', '1', '7', '<1.76', '6', 'mmol/L', '0', '0', '光化学', '1', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '570', '1', '86', result_id, '根据您的检测结果分析如下：\n低密度脂蛋白胆固醇正常值：<3.37mmol/L\nLDL-C水平对个体或群体 ASCVD 发病危险具有独立的预测作用，您的检测值属于合适范围，请继续保持！', '3.32', '0', '1', '6', '<3.37', '3', 'mmol/L', '0', '0', '光化学', '1', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '594', '1', '36', result_id, '根据您的检测结果分析如下：\n总胆/高密比值正常值：<4.0\n您的检测值属于危险界值，有研究显示，与TC/HDL-C<5 者相比，TC/HDL-C≥5的人群罹患冠心病的风险比为2.19，建议及时就医，明确诊断，并在专业人士指导下，进行相关治疗。', '5.8', '0', '1', '9', '<4.0', '7', '', '0', '0', '光化学', '1', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '1513687', '1', '230', result_id, '根据您的检测结果分析如下：\n低密/高密比值正常值：<3.24（男性）＜2.59（女性）\n您的检测值属于危险界值，研究表明，低密高密比值与心脑血管事件相关，是评价冠心病的一项重要指标。建议您注意健康饮食，每天饮食中胆固醇摄入量<200mg，\n饱和脂肪酸摄人量不超过总热量的10%，反式脂肪酸不超过总热量的1%。增加蔬菜、水果、粗纤维食物、富含n-3脂肪酸的鱼类的摄入。', '3.34', '0', '1', '43', '<3.24', '5', '', '0', '1', '--', '1', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '1501402', '1', '227', result_id, '根据您的检测结果分析如下：\n非高密度脂蛋白胆固醇正常值：<4.10mmol/L\n您的检测值属于边缘高值，NON-HDL-C水平更能反映心血管病的危险因素情况，建议您在专业人士指导下，\n结合动脉粥样硬化心血管疾病的其他危险因素的数目和水平进行危险评估。', '4.82', '0', '1', '42', '0-3.39', '5', 'mmol/L', '0', '0', '--', '1', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '526', '1', '16', result_id, '根据您的检测结果分析如下：\n尿酸正常值：男性：＜420μmol/L；女性：＜360μmol/L\n您的尿酸值有点偏高，饮食治疗大约可以降低10%～18%的血尿酸或使血尿酸值降低70～90 μmol/L，建议您均衡饮食，限制每日总热量摄入，避免食用果糖饮料、动物内脏、黄酒、啤酒、白酒，严格限制牛肉、羊肉、猪肉、富含嘌呤的海鲜的摄入，适量食用豆类及豆制品，多食用新鲜蔬菜。', '427', '0', '1', '4', '＜420', '4', 'μmol/L', '0', '1', '电化学', '1', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060820', '557', '1', '31', result_id, '根据您的检测结果分析如下：\n总胆固醇正常值：＜5.18mmol/L\n您的检测值属于边缘高值，总胆固醇（TC）是指血液中各种脂蛋白所含胆固醇之总和，TC值主要受遗传因素与饮食习惯影响，建议您少食含高胆固醇、高饱和脂肪酸食物。', '5.81', '0', '1', '8', '<5.18', '4', 'mmol/L', '0', '0', '光化学', '1', '', '', '0', NULL);

       SET create_date = DATE_SUB(create_date,INTERVAL 1 DAY);
       INSERT INTO scc_medical_result20200811 (patient_id, surveyor_id, create_time, update_time, test_time, status, remark, diagram_data, result_status, customer_id, customer_code, intervene_flag, height_result, weight_result, sex, age, food_status, read_status, coordinate, area_id, remark_photo, legacy_data_flag, send_sms, device_bind_id, data_source, sample_no, apply_id, lot_number, ext_result_id, specimen, specimens, med_record_no, send_checker, review_person, beds, update_user_id, update_user_name, A001, B001, A002, B002, A003, B003, A004, B004, A005, B005, A006, B006, A007, B007, A008, B008, A009, B009, A010, B010, A011, B011, A012, B012, A013, B013, A014, B014, A015, B015, A016, B016, A017, B017, A018, B018, A019, B019, A020, B020, A021, B021, A022, B022, A023, B023, A024, B024, A025, B025, A026, B026, A027, B027, A028, B028, A029, B029, A030, B030, A031, B031, A032, B032, A033, B033, A034, B034, A035, B035, A036, B036, A037, B037, A038, B038, A039, B039, A040, B040, A041, B041, A042, B042, A043, B043, A044, B044, A045, B045, A046, B046, A047, B047, A048, B048, A049, B049, A050, B050, A051, B051, A052, B052, A053, B053, A054, B054, A055, B055, A056, B056, A057, B057, A058, B058, A059, B059, A060, B060, A061, B061, A062, B062, A063, B063, A064, B064, A065, B065, A066, B066, A067, B067, A068, B068, A069, B069, A070, B070, A071, B071, A072, B072, A073, B073, A074, B074, A075, B075, A076, B076, A077, B077, A078, B078, A079, B079, A080, B080, A081, B081, A082, B082, A083, B083, A084, B084, A085, B085, A086, B086, A087, B087, A088, B088, A089, B089, A090, B090, A091, B091, A092, B092, A093, B093, A094, B094, A095, B095, A096, B096, A097, B097, A098, B098, A099, B099, A100, B100, A101, B101, A102, B102, A103, B103, A104, B104, A105, B105, A106, B106, A107, B107, A108, B108, A109, B109, A110, B110) VALUES ('3060859', '589915047', create_date, NULL, create_date, '1', 'yph', NULL, '0', '111133745', '100100506', '0', NULL, NULL, '1', '20', NULL, '1', NULL, NULL, NULL, '0', '0', '0', '0', '', '0', NULL, '0', '0', NULL, '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '140', '4', '100', '5', NULL, NULL, '75', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '140/100', '5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
       SET result_id = LAST_INSERT_ID();
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060859', NULL, NULL, '45', result_id, NULL, '140', '0', '1', '11', '90-139', '4', 'mmHg', '0', '0', '听诊法', '0', '', '', NULL, NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060859', '598', '1', '105', result_id, '根据您的检测结果分析如下：\n脉率正常值：60-100次/分钟\n您的脉搏频率属于正常，请继续保持。', '75', '0', '1', '14', '60-100', '3', '次/分钟', '0', '0', '--', '2', '', '', '0', NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060859', NULL, NULL, '114', result_id, NULL, '100', '0', '1', '12', '60-89', '5', 'mmHg', '0', '0', '听诊法', '0', '', '', NULL, NULL);
       INSERT INTO scc_index_suggest_patient20200811 (patient_id, suggest_id, seq, report_id, result_id, medical_suggest, result, high_risk_flag, status, index_id, medical_reference, medical_status, medical_units, legacy_data_flag, medical_assist_type, medical_method, data_type, device_sn, original_result, sort, device_measure_time) VALUES ('3060859', '460', '1', '133', result_id, '根据您的检测结果分析如下：\n血压正常值：90-119/60-79mmHg\n您的血压值属于中度高血压，建议您在初诊高血压后，进行全面的心血管风险的评估，对于中危患者来说，可以进行一段时间血压监测及危险因素观察后，再决定是否以及何时开始药物治疗；对于高危或很高危患者来说，一旦确诊，应立即开始对高血压及并存的危险因素和临床情况进行综合治疗。', '140/100', '0', '1', '19', '90-139/60-89', '5', 'mmHg', '0', '0', '听诊法', '2', '', '', '0', NULL);

       SET count = count + 1 ;
   END WHILE ;

END

-- CALL SP_CREARTE_RESULT_2020();