1
|
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';
|