-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathUpdate_Database.txt
More file actions
78 lines (71 loc) · 5.53 KB
/
Update_Database.txt
File metadata and controls
78 lines (71 loc) · 5.53 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
UPDATE mcrc_tabelle SET fs_dindo = "5" WHERE fs_dindo = "V";
UPDATE mcrc_tabelle SET fs_dindo = "4b" WHERE fs_dindo = "IVb";
UPDATE mcrc_tabelle SET fs_dindo = "4a" WHERE fs_dindo = "IVa";
UPDATE mcrc_tabelle SET fs_dindo = "3a" WHERE fs_dindo = "IIIa";
UPDATE mcrc_tabelle SET fs_dindo = "3b" WHERE fs_dindo = "IIIb";
UPDATE mcrc_tabelle set fs_dindo = "3a" Where fs_dindo = "III"
UPDATE mcrc_tabelle SET fs_dindo = "2" WHERE fs_dindo = "II";
UPDATE mcrc_tabelle set fs_dindo = "1" Where fs_dindo = "I";
UPDATE mcrc_tabelle SET ss_dindo = "5" WHERE ss_dindo = "V";
UPDATE mcrc_tabelle SET ss_dindo = "4b" WHERE ss_dindo = "IVb";
UPDATE mcrc_tabelle SET ss_dindo = "4a" WHERE ss_dindo = "IVa";
UPDATE mcrc_tabelle SET ss_dindo = "4a" WHERE ss_dindo = "IV";
UPDATE mcrc_tabelle SET ss_dindo = "3a" WHERE ss_dindo = "IIIa";
UPDATE mcrc_tabelle SET ss_dindo = "3b" WHERE ss_dindo = "IIIb";
UPDATE mcrc_tabelle SET ss_dindo = "2" WHERE ss_dindo = "II";
UPDATE mcrc_tabelle set ss_dindo = "1" Where ss_dindo = "I";
UPDATE mcrc_tabelle SET ts_dindo = "5" WHERE ts_dindo = "V";
UPDATE mcrc_tabelle SET ts_dindo = "4b" WHERE ts_dindo = "IVb";
UPDATE mcrc_tabelle SET ts_dindo = "4a" WHERE ts_dindo = "IVa";
UPDATE mcrc_tabelle SET ts_dindo = "3a" WHERE ts_dindo = "IIIa";
UPDATE mcrc_tabelle SET ts_dindo = "3b" WHERE ts_dindo = "IIIb";
UPDATE mcrc_tabelle SET ts_dindo = "2" WHERE ts_dindo = "II";
UPDATE mcrc_tabelle set ts_dindo = "1" Where ts_dindo = "I";
UPDATE mcrc_tabelle set fs_dindo = "No comp" Where fs_dindo = "no complication";
UPDATE mcrc_tabelle set fs_dindo = "No comp" Where fs_dindo = "No complication";
UPDATE mcrc_tabelle set fs_dindo = "No comp" Where fs_dindo = "No complications";
UPDATE mcrc_tabelle set fs_dindo = "No comp" Where fs_dindo = "No Complications";
UPDATE mcrc_tabelle set ts_dindo = "No comp" where fs_dindo = "No Comp";
UPDATE mcrc_tabelle set ss_dindo = "No comp" Where ss_dindo = "no complication";
UPDATE mcrc_tabelle set ss_dindo = "No comp" Where ss_dindo = "No complication";
UPDATE mcrc_tabelle set ss_dindo = "No comp" Where ss_dindo = "No complications";
UPDATE mcrc_tabelle set ss_dindo = "No comp" Where ss_dindo = "No Complications";
UPDATE mcrc_tabelle set ts_dindo = "No comp" where ss_dindo = "No Comp";
UPDATE mcrc_tabelle set ts_dindo = "No comp" Where ts_dindo = "no complication";
UPDATE mcrc_tabelle set ts_dindo = "No comp" Where ts_dindo = "No complication";
UPDATE mcrc_tabelle set ts_dindo = "No comp" Where ts_dindo = "No complications";
UPDATE mcrc_tabelle set ts_dindo = "No comp" Where ts_dindo = "No Complications";
UPDATE mcrc_tabelle set ts_dindo = "No comp" where ts_dindo = "No Comp";
UPDATE mcrc_tabelle set primary_location = "Zäkum" where primary_location = "Zaekum";
UPDATE mcrc_tabelle set primary_location = "Zäkum" where primary_location = "Zoekum"
UPDATE mcrc_tabelle set primary_location = "Zäkum" where primary_location = "Appendix"
UPDATE mcrc_tabelle set primary_location = "Sigma" where primary_location = "Sigmoid";
UPDATE mcrc_tabelle set primary_location = "Sigma" where primary_location = "Sigma\t";
UPDATE mcrc_tabelle set primary_location = "Ascendens" where primary_location = "Flexura coli dextra"
UPDATE mcrc_tabelle set primary_location = "Descendens" where primary_location = "Flexura coli sinistra"
UPDATE mcrc_tabelle set primary_location = "Descendens" where primary_location = "Flexuraq coli sinistra"
UPDATE mcrc_tabelle set primary_location = "Transversum" where primary_location = "Flexura coli transversum"
UPDATE mcrc_tabelle set primary_location = "Rektosigmoid" where primary_location = "RSigma"
UPDATE mcrc_tabelle set primary_location = "Transversum" where primary_location = "Colon transversum"
UPDATE mcrc_tabelle set first_surgery_conversion = "0" where first_surgery_conversion = "no";
UPDATE mcrc_tabelle set first_surgery_conversion = "1" where first_surgery_conversion = "yes";
UPDATE mcrc_tabelle set second_surgery_conversion = "0" where second_surgery_conversion = "no";
UPDATE mcrc_tabelle set second_surgery_conversion = "1" where second_surgery_conversion = "yes";
UPDATE mcrc_tabelle set third_surgery_conversion = "0" where third_surgery_conversion = "no";
UPDATE mcrc_tabelle set third_surgery_conversion = "1" where third_surgery_conversion = "yes";
UPDATE mcrc_tabelle set first_surgery_ablation = "0" where first_surgery_ablation = "no";
UPDATE mcrc_tabelle set first_surgery_ablation = "1" where first_surgery_ablation = "yes";
UPDATE mcrc_tabelle set second_surgery_ablation = "0" where second_surgery_ablation = "no";
UPDATE mcrc_tabelle set second_surgery_ablation = "1" where second_surgery_ablation = "yes";
UPDATE mcrc_tabelle set third_surgery_ablation = "0" where third_surgery_ablation = "no";
UPDATE mcrc_tabelle set third_surgery_ablation = "1" where third_surgery_ablation = "yes";
UPDATE mcrc_tabelle set second_surgery_planned = "0" where second_surgery_planned = "no";
UPDATE mcrc_tabelle set second_surgery_planned = "1" where second_surgery_planned = "yes";
UPDATE mcrc_tabelle set third_surgery_planned = "0" where third_surgery_planned = "no";
UPDATE mcrc_tabelle set third_surgery_planned = "1" where third_surgery_planned = "yes";
UPDATE mcrc_tabelle set second_surgery_realized = "0" where second_surgery_realized = "no";
UPDATE mcrc_tabelle set second_surgery_realized = "1" where second_surgery_realized = "yes";
UPDATE mcrc_tabelle set third_surgery_realized = "0" where third_surgery_realized = "no";
UPDATE mcrc_tabelle set third_surgery_realized = "1" where third_surgery_realized = "yes";
UPDATE mcrc_tabelle set MSS = "mss" where MSS = "wt";
UDPATE mcrc_tabelle set MSS = "msi" where MSS = "mut";