1 |
57810
|
alessia.ba
|
update dsm_organizations set country='TW' where country='Taiwan';
|
2 |
|
|
|
3 |
|
|
update dsm_organizations set country='NL' where country='Netherlands';
|
4 |
|
|
|
5 |
|
|
update dsm_organizations set country='NA' where country='NAM';
|
6 |
|
|
|
7 |
|
|
update dsm_organizations set country='KZ' where country='KAZ';
|
8 |
|
|
|
9 |
|
|
update dsm_organizations set country='IL' where country='Israel';
|
10 |
|
|
|
11 |
|
|
update dsm_organizations set country='US' where country='United States';
|
12 |
|
|
|
13 |
|
|
update dsm_organizations set country='DE' where country='Germany';
|
14 |
|
|
|
15 |
|
|
update dsm_organizations set country='CA' where country='Canada';
|
16 |
|
|
|
17 |
|
|
update dsm_organizations set country='LK' where country='LKA';
|
18 |
|
|
|
19 |
|
|
update dsm_organizations set country='CD' where country ='Congo, the Democratic Republic of the';
|
20 |
|
|
update dsm_organizations set country='CD' where country like 'Congo Democratic%';
|
21 |
|
|
update dsm_organizations set country='CD' where country = 'Zaire';
|
22 |
|
|
|
23 |
|
|
update dsm_organizations set country='FI' where country = 'Finland';
|
24 |
|
|
|
25 |
|
|
update dsm_organizations set country='MX' where country = 'Mexico';
|
26 |
|
|
update dsm_organizations set country='GB' where country = 'United Kingdom';
|