-- 环境1 UPDATE `tbl-master-prize` SET agent_name = 'ID000001' WHERE agent_id = 1 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000002' WHERE agent_id = 3 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000004' WHERE agent_id = 9 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000005' WHERE agent_id = 10 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000006' WHERE agent_id = 11 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000007' WHERE agent_id = 12 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000008' WHERE agent_id = 13 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000009' WHERE agent_id = 14 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000010' WHERE agent_id = 15 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000011' WHERE agent_id = 16 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000012' WHERE agent_id = 17 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000013' WHERE agent_id = 18 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000014' WHERE agent_id = 19 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000015' WHERE agent_id = 20 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000016' WHERE agent_id = 21 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000017' WHERE agent_id = 22 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000018' WHERE agent_id = 23 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000019' WHERE agent_id = 24 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000020' WHERE agent_id = 25 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000021' WHERE agent_id = 26 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000022' WHERE agent_id = 27 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000023' WHERE agent_id = 28 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000024' WHERE agent_id = 29 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000025' WHERE agent_id = 30 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000026' WHERE agent_id = 31 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000027' WHERE agent_id = 32 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000028' WHERE agent_id = 33 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000029' WHERE agent_id = 34 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000030' WHERE agent_id = 35 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000031' WHERE agent_id = 36 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000032' WHERE agent_id = 37 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000033' WHERE agent_id = 38 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000034' WHERE agent_id = 39 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000035' WHERE agent_id = 40 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000036' WHERE agent_id = 41 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000037' WHERE agent_id = 42 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000038' WHERE agent_id = 43 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000039' WHERE agent_id = 44 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000040' WHERE agent_id = 45 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000041' WHERE agent_id = 46 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000042' WHERE agent_id = 47 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000043' WHERE agent_id = 48 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000044' WHERE agent_id = 49 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000045' WHERE agent_id = 50 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000046' WHERE agent_id = 51 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000047' WHERE agent_id = 52 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000048' WHERE agent_id = 53 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000049' WHERE agent_id = 54 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000050' WHERE agent_id = 55 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000051' WHERE agent_id = 56 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000052' WHERE agent_id = 57 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000053' WHERE agent_id = 58 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000054' WHERE agent_id = 59 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000055' WHERE agent_id = 60 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000056' WHERE agent_id = 61 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000057' WHERE agent_id = 62 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000058' WHERE agent_id = 63 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000059' WHERE agent_id = 64 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000060' WHERE agent_id = 65 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000061' WHERE agent_id = 66 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000062' WHERE agent_id = 67 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000063' WHERE agent_id = 68 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000064' WHERE agent_id = 69 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000065' WHERE agent_id = 70 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000066' WHERE agent_id = 71 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000067' WHERE agent_id = 72 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000068' WHERE agent_id = 73 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000069' WHERE agent_id = 74 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000070' WHERE agent_id = 150078 ; UPDATE `tbl-master-prize` SET agent_name = 'ID000071' WHERE agent_id = 210079 ; -- 环境2 UPDATE `tbl-master-prize` SET agent_name = 'SID000001' WHERE agent_id = 10000; UPDATE `tbl-master-prize` SET agent_name = 'SID000002' WHERE agent_id = 10011; UPDATE `tbl-master-prize` SET agent_name = 'SID000003' WHERE agent_id = 10012; UPDATE `tbl-master-prize` SET agent_name = 'SID000004' WHERE agent_id = 10013; UPDATE `tbl-master-prize` SET agent_name = 'SID000005' WHERE agent_id = 10014; UPDATE `tbl-master-prize` SET agent_name = 'SID000006' WHERE agent_id = 10015 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000007' WHERE agent_id = 10016 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000008' WHERE agent_id = 10017 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000009' WHERE agent_id = 10018 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000010' WHERE agent_id = 10019 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000011' WHERE agent_id = 10020 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000042' WHERE agent_id = 10023 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000043' WHERE agent_id = 10024 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000044' WHERE agent_id = 10025 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000045' WHERE agent_id = 10026 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000046' WHERE agent_id = 10027 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000047' WHERE agent_id = 10028 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000048' WHERE agent_id = 10029 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000049' WHERE agent_id = 10030 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000050' WHERE agent_id = 10031 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000051' WHERE agent_id = 10032 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000052' WHERE agent_id = 10033 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000053' WHERE agent_id = 10034 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000054' WHERE agent_id = 10035 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000055' WHERE agent_id = 10036 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000056' WHERE agent_id = 10037 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000057' WHERE agent_id = 10038 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000058' WHERE agent_id = 10039 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000059' WHERE agent_id = 10040 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000060' WHERE agent_id = 10041 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000061' WHERE agent_id = 10042 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000062' WHERE agent_id = 10043 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000063' WHERE agent_id = 10044 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000012' WHERE agent_id = 40002 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000013' WHERE agent_id = 40003 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000014' WHERE agent_id = 40004 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000015' WHERE agent_id = 40005 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000016' WHERE agent_id = 40006 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000017' WHERE agent_id = 40007 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000018' WHERE agent_id = 40008 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000019' WHERE agent_id = 40009 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000020' WHERE agent_id = 40010 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000021' WHERE agent_id = 40011 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000022' WHERE agent_id = 40012 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000023' WHERE agent_id = 40013 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000024' WHERE agent_id = 40014 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000025' WHERE agent_id = 40015 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000026' WHERE agent_id = 40016 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000027' WHERE agent_id = 40017 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000028' WHERE agent_id = 40018 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000029' WHERE agent_id = 40019 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000030' WHERE agent_id = 40020 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000031' WHERE agent_id = 40021 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000032' WHERE agent_id = 40022 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000033' WHERE agent_id = 40023 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000034' WHERE agent_id = 40024 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000035' WHERE agent_id = 40025 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000036' WHERE agent_id = 40026 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000037' WHERE agent_id = 40027 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000038' WHERE agent_id = 40028 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000039' WHERE agent_id = 40029 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000040' WHERE agent_id = 40030 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000041' WHERE agent_id = 40031 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000064' WHERE agent_id = 70000 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000065' WHERE agent_id = 70001 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000066' WHERE agent_id = 70002 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000067' WHERE agent_id = 70003 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000068' WHERE agent_id = 70004 ; UPDATE `tbl-master-prize` SET agent_name = 'SID000069' WHERE agent_id = 100000; UPDATE `tbl-master-prize` SET agent_name = 'SID000070' WHERE agent_id = 100001; UPDATE `tbl-master-prize` SET agent_name = 'SID000071' WHERE agent_id = 130000; UPDATE `tbl-master-prize` SET agent_name = 'SID000072' WHERE agent_id = 130001; UPDATE `tbl-master-prize` SET agent_name = 'SID000073' WHERE agent_id = 160000; UPDATE `tbl-master-prize` SET agent_name = 'SID000074' WHERE agent_id = 280000; UPDATE `tbl-master-prize` SET agent_name = 'SID000075' WHERE agent_id = 310000; UPDATE `tbl-master-prize` SET agent_name = 'SID000076' WHERE agent_id = 340000; UPDATE `tbl-master-prize` SET agent_name = 'SID000077' WHERE agent_id = 370000; UPDATE `tbl-master-prize` SET agent_name = 'SID000078' WHERE agent_id = 400000; UPDATE `tbl-master-prize` SET agent_name = 'SID000079' WHERE agent_id = 400001; UPDATE `tbl-master-prize` SET agent_name = 'SID000080' WHERE agent_id = 400002; UPDATE `tbl-master-prize` SET agent_name = 'SID000081' WHERE agent_id = 400003; UPDATE `tbl-master-prize` SET agent_name = 'SID000082' WHERE agent_id = 430000; UPDATE `tbl-master-prize` SET agent_name = 'SID000083' WHERE agent_id = 430001; UPDATE `tbl-master-prize` SET agent_name = 'SID000084' WHERE agent_id = 460000;