ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/examples/scriptengine/tests/CreateCountriesTable.sql
Revision: 37
Committed: Mon Feb 15 14:44:25 2016 UTC (8 years, 9 months ago) by tony
Content type: application/sql
File size: 32632 byte(s)
Log Message: 
Committing updates for Release R1-4-0

File Contents

# Content
1 CREATE Table COUNTRIES (
2 COUNTRY varchar(64) not null,
3 NonEU SmallInt,
4 ISO2 Char(2),
5 ISO3 Char(3),
6 Primary Key(COUNTRY)
7 );
8
9 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Afghanistan', '1', 'AF', 'AFG') Matching (COUNTRY);
10 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Aland Islands', '1', 'AX', 'ALA') Matching (COUNTRY);
11 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Albania', '1', 'AL', 'ALB') Matching (COUNTRY);
12 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Algeria', '1', 'DZ', 'DZA') Matching (COUNTRY);
13 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('American Samoa', '1', 'AS', 'ASM') Matching (COUNTRY);
14 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Andorra', '1', 'AD', 'AND') Matching (COUNTRY);
15 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Angola', '1', 'AO', 'AGO') Matching (COUNTRY);
16 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Anguilla', '1', 'AI', 'AIA') Matching (COUNTRY);
17 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Antarctica', '1', 'AQ', 'ATA') Matching (COUNTRY);
18 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Antigua and Barbuda', '1', 'AG', 'ATG') Matching (COUNTRY);
19 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Argentina', '1', 'AR', 'ARG') Matching (COUNTRY);
20 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Armenia', '1', 'AM', 'ARM') Matching (COUNTRY);
21 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Aruba', '1', 'AW', 'ABW') Matching (COUNTRY);
22 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Australia', '1', 'AU', 'AUS') Matching (COUNTRY);
23 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Austria', '0', 'AT', 'AUT') Matching (COUNTRY);
24 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Azerbaijan', '1', 'AZ', 'AZE') Matching (COUNTRY);
25 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bahamas', '1', 'BS', 'BHS') Matching (COUNTRY);
26 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bahrain', '1', 'BH', 'BHR') Matching (COUNTRY);
27 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bangladesh', '1', 'BD', 'BGD') Matching (COUNTRY);
28 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Barbados', '1', 'BB', 'BRB') Matching (COUNTRY);
29 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Belarus', '1', 'BY', 'BLR') Matching (COUNTRY);
30 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Belgium', '0', 'BE', 'BEL') Matching (COUNTRY);
31 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Belize', '1', 'BZ', 'BLZ') Matching (COUNTRY);
32 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Benin', '1', 'BJ', 'BEN') Matching (COUNTRY);
33 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bermuda', '1', 'BM', 'BMU') Matching (COUNTRY);
34 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bhutan', '1', 'BT', 'BTN') Matching (COUNTRY);
35 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bolivia', '1', NULL, NULL) Matching (COUNTRY);
36 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bolivia, Plurinational State of', '1', 'BO', 'BOL') Matching (COUNTRY);
37 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bonaire, Saint Eustatius and Saba', '1', 'BQ', 'BES') Matching (COUNTRY);
38 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bosnia and Herzegovina', '1', 'BA', 'BIH') Matching (COUNTRY);
39 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Botswana', '1', 'BW', 'BWA') Matching (COUNTRY);
40 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bouvet Island', '1', 'BV', 'BVT') Matching (COUNTRY);
41 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Brazil', '1', 'BR', 'BRA') Matching (COUNTRY);
42 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('British Indian Ocean Territory', '1', 'IO', 'IOT') Matching (COUNTRY);
43 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Brunei Darussalam', '1', 'BN', 'BRN') Matching (COUNTRY);
44 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Bulgaria', '1', 'BG', 'BGR') Matching (COUNTRY);
45 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Burkina Faso', '1', 'BF', 'BFA') Matching (COUNTRY);
46 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Burundi', '1', 'BI', 'BDI') Matching (COUNTRY);
47 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cambodia', '1', 'KH', 'KHM') Matching (COUNTRY);
48 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cameroon', '1', 'CM', 'CMR') Matching (COUNTRY);
49 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Canada', '1', 'CA', 'CAN') Matching (COUNTRY);
50 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cape Verde', '1', 'CV', 'CPV') Matching (COUNTRY);
51 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cayman Islands', '1', 'KY', 'CYM') Matching (COUNTRY);
52 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Central African Republic', '1', 'CF', 'CAF') Matching (COUNTRY);
53 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Chad', '1', 'TD', 'TCD') Matching (COUNTRY);
54 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Chile', '1', 'CL', 'CHL') Matching (COUNTRY);
55 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('China', '1', 'CN', 'CHN') Matching (COUNTRY);
56 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Christmas Island', '1', 'CX', 'CXR') Matching (COUNTRY);
57 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cocos (Keeling) Islands', '1', 'CC', 'CCK') Matching (COUNTRY);
58 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Colombia', '1', 'CO', 'COL') Matching (COUNTRY);
59 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Comoros', '1', 'KM', 'COM') Matching (COUNTRY);
60 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Congo', '1', 'CG', 'COG') Matching (COUNTRY);
61 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Congo, the Democratic Republic of the', '1', 'CD', 'COD') Matching (COUNTRY);
62 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cook Islands', '1', 'CK', 'COK') Matching (COUNTRY);
63 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Costa Rica', '1', 'CR', 'CRI') Matching (COUNTRY);
64 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cote d''Ivoire', '1', 'CI', NULL) Matching (COUNTRY);
65 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Croatia', '1', 'HR', 'HRV') Matching (COUNTRY);
66 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cuba', '1', 'CU', 'CUB') Matching (COUNTRY);
67 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Curaçao', '1', 'CW', 'CUW') Matching (COUNTRY);
68 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Cyprus', '0', 'CY', 'CYP') Matching (COUNTRY);
69 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Czech Republic', '0', 'CZ', 'CZE') Matching (COUNTRY);
70 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Côte d''Ivoire', '1', NULL, 'CIV') Matching (COUNTRY);
71 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Democratic People''s Republic of Korea', '1', NULL, NULL) Matching (COUNTRY);
72 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Democratic Republic of the Congo', '1', NULL, NULL) Matching (COUNTRY);
73 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Denmark', '0', 'DK', 'DNK') Matching (COUNTRY);
74 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Djibouti', '1', 'DJ', 'DJI') Matching (COUNTRY);
75 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Dominica', '1', 'DM', 'DMA') Matching (COUNTRY);
76 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Dominican Republic', '1', 'DO', 'DOM') Matching (COUNTRY);
77 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ecuador', '1', 'EC', 'ECU') Matching (COUNTRY);
78 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Egypt', '1', 'EG', 'EGY') Matching (COUNTRY);
79 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('El Salvador', '1', 'SV', 'SLV') Matching (COUNTRY);
80 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('England', '0', NULL, NULL) Matching (COUNTRY);
81 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Equatorial Guinea', '1', 'GQ', 'GNQ') Matching (COUNTRY);
82 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Eritrea', '1', 'ER', 'ERI') Matching (COUNTRY);
83 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Estonia', '0', 'EE', 'EST') Matching (COUNTRY);
84 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ethiopia', '1', 'ET', 'ETH') Matching (COUNTRY);
85 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Falkland Islands (Malvinas)', '1', 'FK', 'FLK') Matching (COUNTRY);
86 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Faroe Islands', '1', 'FO', 'FRO') Matching (COUNTRY);
87 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Federated States of Micronesia', '1', NULL, NULL) Matching (COUNTRY);
88 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Fiji', '1', 'FJ', 'FJI') Matching (COUNTRY);
89 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Finland', '0', 'FI', 'FIN') Matching (COUNTRY);
90 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('France', '0', 'FR', 'FRA') Matching (COUNTRY);
91 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('French Guiana', '1', 'GF', 'GUF') Matching (COUNTRY);
92 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('French Polynesia', '1', 'PF', 'PYF') Matching (COUNTRY);
93 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('French Southern Territories', '1', 'TF', 'ATF') Matching (COUNTRY);
94 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Gabon', '1', 'GA', 'GAB') Matching (COUNTRY);
95 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Gambia', '1', 'GM', 'GMB') Matching (COUNTRY);
96 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Georgia', '1', 'GE', 'GEO') Matching (COUNTRY);
97 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Germany', '0', 'DE', 'DEU') Matching (COUNTRY);
98 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ghana', '1', 'GH', 'GHA') Matching (COUNTRY);
99 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Gibraltar', '1', 'GI', 'GIB') Matching (COUNTRY);
100 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Greece', '0', 'GR', 'GRC') Matching (COUNTRY);
101 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Greenland', '1', 'GL', 'GRL') Matching (COUNTRY);
102 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Grenada', '1', 'GD', 'GRD') Matching (COUNTRY);
103 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guadeloupe', '1', 'GP', 'GLP') Matching (COUNTRY);
104 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guam', '1', 'GU', 'GUM') Matching (COUNTRY);
105 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guatemala', '1', 'GT', 'GTM') Matching (COUNTRY);
106 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guernsey', '1', 'GG', 'GGY') Matching (COUNTRY);
107 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guinea', '1', 'GN', 'GIN') Matching (COUNTRY);
108 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guinea-Bissau', '1', 'GW', 'GNB') Matching (COUNTRY);
109 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Guyana', '1', 'GY', 'GUY') Matching (COUNTRY);
110 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Haiti', '1', 'HT', 'HTI') Matching (COUNTRY);
111 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Heard Island and McDonald Islands', '1', 'HM', 'HMD') Matching (COUNTRY);
112 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Holy See (Vatican City State)', '1', 'VA', 'VAT') Matching (COUNTRY);
113 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Honduras', '1', 'HN', 'HND') Matching (COUNTRY);
114 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Hong Kong', '1', 'HK', 'HKG') Matching (COUNTRY);
115 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Hungary', '0', 'HU', 'HUN') Matching (COUNTRY);
116 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Iceland', '1', 'IS', 'ISL') Matching (COUNTRY);
117 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('India', '1', 'IN', 'IND') Matching (COUNTRY);
118 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Indonesia', '1', 'ID', 'IDN') Matching (COUNTRY);
119 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Iran, Islamic Republic of', '1', 'IR', 'IRN') Matching (COUNTRY);
120 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Iraq', '1', 'IQ', 'IRQ') Matching (COUNTRY);
121 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ireland', '0', 'IE', 'IRL') Matching (COUNTRY);
122 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Isle of Man', '1', 'IM', 'IMN') Matching (COUNTRY);
123 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Israel', '1', 'IL', 'ISR') Matching (COUNTRY);
124 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Italy', '0', 'IT', 'ITA') Matching (COUNTRY);
125 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ivory Coast', '1', NULL, NULL) Matching (COUNTRY);
126 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Jamaica', '1', 'JM', 'JAM') Matching (COUNTRY);
127 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Japan', '1', 'JP', 'JPN') Matching (COUNTRY);
128 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Jersey', '1', 'JE', 'JEY') Matching (COUNTRY);
129 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Jordan', '1', 'JO', 'JOR') Matching (COUNTRY);
130 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kazakhstan', '1', 'KZ', 'KAZ') Matching (COUNTRY);
131 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kenya', '1', 'KE', 'KEN') Matching (COUNTRY);
132 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kiribati', '1', 'KI', 'KIR') Matching (COUNTRY);
133 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Korea', '1', NULL, NULL) Matching (COUNTRY);
134 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Korea, Democratic People''s Republic of', '1', 'KP', 'PRK') Matching (COUNTRY);
135 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Korea, Republic of', '1', 'KR', 'KOR') Matching (COUNTRY);
136 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kosovo', '1', NULL, NULL) Matching (COUNTRY);
137 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kuwait', '1', 'KW', 'KWT') Matching (COUNTRY);
138 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Kyrgyzstan', '1', 'KG', 'KGZ') Matching (COUNTRY);
139 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Lao People''s Democratic Republic', '1', 'LA', 'LAO') Matching (COUNTRY);
140 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Latvia', '0', 'LV', 'LVA') Matching (COUNTRY);
141 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Lebanon', '1', 'LB', 'LBN') Matching (COUNTRY);
142 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Lesotho', '1', 'LS', 'LSO') Matching (COUNTRY);
143 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Liberia', '1', 'LR', 'LBR') Matching (COUNTRY);
144 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Libyan Arab Jamahiriya', '1', 'LY', 'LBY') Matching (COUNTRY);
145 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Liechtenstein', '1', 'LI', 'LIE') Matching (COUNTRY);
146 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Lithuania', '0', 'LT', 'LTU') Matching (COUNTRY);
147 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Luxembourg', '0', 'LU', 'LUX') Matching (COUNTRY);
148 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Macao', '1', 'MO', 'MAC') Matching (COUNTRY);
149 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Macedonia, the former Yugoslav Republic of', '1', 'MK', 'MKD') Matching (COUNTRY);
150 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Madagascar', '1', 'MG', 'MDG') Matching (COUNTRY);
151 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Malawi', '1', 'MW', 'MWI') Matching (COUNTRY);
152 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Malaysia', '1', 'MY', 'MYS') Matching (COUNTRY);
153 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Maldives', '1', 'MV', 'MDV') Matching (COUNTRY);
154 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mali', '1', 'ML', 'MLI') Matching (COUNTRY);
155 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Malta', '0', 'MT', 'MLT') Matching (COUNTRY);
156 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Marshall Islands', '1', 'MH', 'MHL') Matching (COUNTRY);
157 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Martinique', '1', 'MQ', 'MTQ') Matching (COUNTRY);
158 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mauritania', '1', 'MR', 'MRT') Matching (COUNTRY);
159 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mauritius', '1', 'MU', 'MUS') Matching (COUNTRY);
160 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mayotte', '1', 'YT', 'MYT') Matching (COUNTRY);
161 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mexico', '1', 'MX', 'MEX') Matching (COUNTRY);
162 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Micronesia, Federated States of', '1', 'FM', 'FSM') Matching (COUNTRY);
163 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Moldova, Republic of', '1', 'MD', 'MDA') Matching (COUNTRY);
164 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Monaco', '0', 'MC', 'MCO') Matching (COUNTRY);
165 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mongolia', '1', 'MN', 'MNG') Matching (COUNTRY);
166 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Montenegro', '0', 'ME', 'MNE') Matching (COUNTRY);
167 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Montserrat', '1', 'MS', 'MSR') Matching (COUNTRY);
168 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Morocco', '1', 'MA', 'MAR') Matching (COUNTRY);
169 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Mozambique', '1', 'MZ', 'MOZ') Matching (COUNTRY);
170 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Myanmar', '1', 'MM', 'MMR') Matching (COUNTRY);
171 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Namibia', '1', 'NA', 'NAM') Matching (COUNTRY);
172 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Nauru', '1', 'NR', 'NRU') Matching (COUNTRY);
173 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Nepal', '1', 'NP', 'NPL') Matching (COUNTRY);
174 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Netherlands', '1', 'NL', 'NLD') Matching (COUNTRY);
175 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('New Caledonia', '1', 'NC', 'NCL') Matching (COUNTRY);
176 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('New Zealand', '1', 'NZ', 'NZL') Matching (COUNTRY);
177 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Nicaragua', '1', 'NI', 'NIC') Matching (COUNTRY);
178 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Niger', '1', 'NE', 'NER') Matching (COUNTRY);
179 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Nigeria', '1', 'NG', 'NGA') Matching (COUNTRY);
180 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Niue', '1', 'NU', 'NIU') Matching (COUNTRY);
181 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Norfolk Island', '1', 'NF', 'NFK') Matching (COUNTRY);
182 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Northern Ireland', '0', NULL, NULL) Matching (COUNTRY);
183 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Northern Mariana Islands', '1', 'MP', 'MNP') Matching (COUNTRY);
184 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Norway', '1', 'NO', 'NOR') Matching (COUNTRY);
185 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Oman', '1', 'OM', 'OMN') Matching (COUNTRY);
186 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Pakistan', '1', 'PK', 'PAK') Matching (COUNTRY);
187 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Palau', '1', 'PW', 'PLW') Matching (COUNTRY);
188 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Palestinian Territory, Occupied', '1', 'PS', 'PSE') Matching (COUNTRY);
189 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Panama', '1', 'PA', 'PAN') Matching (COUNTRY);
190 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Papua New Guinea', '1', 'PG', 'PNG') Matching (COUNTRY);
191 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Paraguay', '1', 'PY', 'PRY') Matching (COUNTRY);
192 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Peru', '1', 'PE', 'PER') Matching (COUNTRY);
193 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Philippines', '1', 'PH', 'PHL') Matching (COUNTRY);
194 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Pitcairn', '1', 'PN', 'PCN') Matching (COUNTRY);
195 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Poland', '0', 'PL', 'POL') Matching (COUNTRY);
196 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Portugal', '0', 'PT', 'PRT') Matching (COUNTRY);
197 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Puerto Rico', '1', 'PR', 'PRI') Matching (COUNTRY);
198 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Qatar', '1', 'QA', 'QAT') Matching (COUNTRY);
199 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Republic of Palau', '1', NULL, NULL) Matching (COUNTRY);
200 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Reunion', '1', NULL, NULL) Matching (COUNTRY);
201 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Romania', '1', 'RO', 'ROU') Matching (COUNTRY);
202 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Russian Federation', '1', 'RU', 'RUS') Matching (COUNTRY);
203 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Rwanda', '1', 'RW', 'RWA') Matching (COUNTRY);
204 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Réunion', '1', 'RE', 'REU') Matching (COUNTRY);
205 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Barthélemy', '1', 'BL', 'BLM') Matching (COUNTRY);
206 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Helena, Ascension and Tristan da Cunha', '1', 'SH', 'SHN') Matching (COUNTRY);
207 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Kitts and Nevis', '1', 'KN', 'KNA') Matching (COUNTRY);
208 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Lucia', '1', 'LC', 'LCA') Matching (COUNTRY);
209 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Martin (French part)', '1', 'MF', 'MAF') Matching (COUNTRY);
210 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Pierre and Miquelon', '1', 'PM', 'SPM') Matching (COUNTRY);
211 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saint Vincent and the Grenadines', '1', 'VC', 'VCT') Matching (COUNTRY);
212 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Samoa', '1', 'WS', 'WSM') Matching (COUNTRY);
213 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('San Marino', '0', 'SM', 'SMR') Matching (COUNTRY);
214 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sao Tome and Principe', '1', 'ST', 'STP') Matching (COUNTRY);
215 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Saudi Arabia', '1', 'SA', 'SAU') Matching (COUNTRY);
216 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Scotland', '0', NULL, NULL) Matching (COUNTRY);
217 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Senegal', '1', 'SN', 'SEN') Matching (COUNTRY);
218 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Serbia', '1', 'RS', 'SRB') Matching (COUNTRY);
219 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Seychelles', '1', 'SC', 'SYC') Matching (COUNTRY);
220 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sierra Leone', '1', 'SL', 'SLE') Matching (COUNTRY);
221 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Singapore', '1', 'SG', 'SGP') Matching (COUNTRY);
222 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sint Maarten (Dutch part)', '1', 'SX', 'SXM') Matching (COUNTRY);
223 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Slovakia', '1', 'SK', 'SVK') Matching (COUNTRY);
224 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Slovenia', '0', 'SI', 'SVN') Matching (COUNTRY);
225 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Solomon Islands', '1', 'SB', 'SLB') Matching (COUNTRY);
226 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Somalia', '1', 'SO', 'SOM') Matching (COUNTRY);
227 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('South Africa', '1', 'ZA', 'ZAF') Matching (COUNTRY);
228 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('South Georgia and the South Sandwich Islands', '1', 'GS', 'SGS') Matching (COUNTRY);
229 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('South Korea', '1', NULL, NULL) Matching (COUNTRY);
230 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Spain', '0', 'ES', 'ESP') Matching (COUNTRY);
231 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sri Lanka', '1', 'LK', 'LKA') Matching (COUNTRY);
232 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sudan', '1', 'SD', 'SDN') Matching (COUNTRY);
233 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Suriname', '1', 'SR', 'SUR') Matching (COUNTRY);
234 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Svalbard and Jan Mayen', '1', 'SJ', 'SJM') Matching (COUNTRY);
235 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Swaziland', '1', 'SZ', 'SWZ') Matching (COUNTRY);
236 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Sweden', '0', 'SE', 'SWE') Matching (COUNTRY);
237 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Switzerland', '1', 'CH', 'CHE') Matching (COUNTRY);
238 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Syrian Arab Republic', '1', 'SY', 'SYR') Matching (COUNTRY);
239 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tahiti', '1', NULL, NULL) Matching (COUNTRY);
240 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Taiwan', '1', 'TW', 'TWN') Matching (COUNTRY);
241 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tajikistan', '1', 'TJ', 'TJK') Matching (COUNTRY);
242 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tanzania, United Republic of', '1', 'TZ', 'TZA') Matching (COUNTRY);
243 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Thailand', '1', 'TH', 'THA') Matching (COUNTRY);
244 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Timor-Leste', '1', 'TL', 'TLS') Matching (COUNTRY);
245 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Togo', '1', 'TG', 'TGO') Matching (COUNTRY);
246 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tokelau', '1', 'TK', 'TKL') Matching (COUNTRY);
247 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tonga', '1', 'TO', 'TON') Matching (COUNTRY);
248 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Trinidad and Tobago', '1', 'TT', 'TTO') Matching (COUNTRY);
249 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tunisia', '1', 'TN', 'TUN') Matching (COUNTRY);
250 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Turkey', '1', 'TR', 'TUR') Matching (COUNTRY);
251 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Turkmenistan', '1', 'TM', 'TKM') Matching (COUNTRY);
252 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Turks and Caicos Islands', '1', 'TC', 'TCA') Matching (COUNTRY);
253 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Tuvalu', '1', 'TV', 'TUV') Matching (COUNTRY);
254 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Uganda', '1', 'UG', 'UGA') Matching (COUNTRY);
255 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Ukraine', '1', 'UA', 'UKR') Matching (COUNTRY);
256 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('United Arab Emirates', '1', 'AE', 'ARE') Matching (COUNTRY);
257 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('United Kingdom', '0', 'GB', 'GBR') Matching (COUNTRY);
258 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('United States', '1', 'US', 'USA') Matching (COUNTRY);
259 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('United States Minor Outlying Islands', '1', 'UM', 'UMI') Matching (COUNTRY);
260 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Uruguay', '1', 'UY', 'URY') Matching (COUNTRY);
261 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Uzbekistan', '1', 'UZ', 'UZB') Matching (COUNTRY);
262 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Vanuatu', '1', 'VU', 'VUT') Matching (COUNTRY);
263 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Venezuela', '1', NULL, NULL) Matching (COUNTRY);
264 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Venezuela, Bolivarian Republic of', '1', 'VE', 'VEN') Matching (COUNTRY);
265 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Viet Nam', '1', 'VN', 'VNM') Matching (COUNTRY);
266 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Virgin Islands, British', '1', 'VG', 'VGB') Matching (COUNTRY);
267 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Virgin Islands, U.S.', '1', 'VI', 'VIR') Matching (COUNTRY);
268 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Wales', '0', NULL, NULL) Matching (COUNTRY);
269 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Wallis and Futuna', '1', 'WF', 'WLF') Matching (COUNTRY);
270 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Western Sahara', '1', 'EH', 'ESH') Matching (COUNTRY);
271 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Yemen', '1', 'YE', 'YEM') Matching (COUNTRY);
272 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Zambia', '1', 'ZM', 'ZMB') Matching (COUNTRY);
273 UPDATE or INSERT INTO COUNTRIES (COUNTRY, NONEU, ISO2, ISO3) VALUES ('Zimbabwe', '1', 'ZW', 'ZWE') Matching (COUNTRY);
274 Commit;
275 Select * From COUNTRIES;