SQL Country Codes and Names Import Script for ArtenSUITE

If you are creating a database or website and need to populate a table with the Country Codes and Names then the following may be of use to you. I created this this morning for ArtenSUITE. Feel free to copy and modify this code. BAS_CHO_CCRY is the table name and the words prefixed with CRY_ are the column names.



INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AF','Afghanistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AX','Aland Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AL','Albania',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DZ','Algeria',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AS','American Samoa',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AD','Andorra',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AO','Angola',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AI','Anguilla',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AQ','Antarctica',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AG','Antigua and Barbuda',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AR','Argentina',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AM','Armenia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AW','Aruba',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AU','Australia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AT','Austria',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AZ','Azerbaijan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BS','Bahamas',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BH','Bahrain',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BD','Bangladesh',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BB','Barbados',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BY','Belarus',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BE','Belgium',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BZ','Belize',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BJ','Benin',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BM','Bermuda',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BT','Bhutan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BO','Bolivia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BA','Bosnia and Herzegovina',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BW','Botswana',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BV','Bouvet Island',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BR','Brazil',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IO','British Indian Ocean Territory',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BN','Brunei Darussalam',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BG','Bulgaria',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BF','Burkina Faso',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BI','Burundi',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KH','Cambodia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CM','Cameroon',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CA','Canada',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CV','Cape Verde',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KY','Cayman Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CF','Central African Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TD','Chad',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CL','Chile',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CN','China',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CX','Christmas Island',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CC','Cocos (Keeling) Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CO','Colombia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KM','Comoros',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CG','Congo',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CD','Congo, The Democratic Republic of the',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CK','Cook Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CR','Costa Rica',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CI','Côte DIvoire',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HR','Croatia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CU','Cuba',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CY','Cyprus',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CZ','Czech Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DK','Denmark',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DJ','Djibouti',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DM','Dominica',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DO','Dominican Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('EC','Ecuador',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('EG','Egypt',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SV','El Salvador',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GQ','Equatorial Guinea',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ER','Eritrea',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('EE','Estonia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ET','Ethiopia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FK','Falkland Islands (Malvinas)',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FO','Faroe Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FJ','Fiji',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FI','Finland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FR','France',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GF','French Guiana',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PF','French Polynesia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TF','French Southern Territories',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GA','Gabon',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GM','Gambia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GE','Georgia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('DE','Germany',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GH','Ghana',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GI','Gibraltar',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GR','Greece',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GL','Greenland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GD','Grenada',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GP','Guadeloupe',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GU','Guam',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GT','Guatemala',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GG','Guernsey',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GN','Guinea',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GW','Guinea-Bissau',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GY','Guyana',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HT','Haiti',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HM','Heard Island and McDonald Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VA','Holy See (Vatican City State)',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HN','Honduras',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HK','Hong Kong',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('HU','Hungary',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IS','Iceland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IN','India',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ID','Indonesia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IR','Iran, Islamic Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IQ','Iraq',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IE','Ireland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IM','Isle of Man',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IL','Israel',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('IT','Italy',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('JM','Jamaica',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('JP','Japan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('JE','Jersey',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('JO','Jordan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KZ','Kazakhstan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KE','Kenya',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KI','Kiribati',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KP','Korea, Democratic Peoples Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KR','Korea, Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KW','Kuwait',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KG','Kyrgyzstan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LA','Lao Peoples Democratic Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LV','Latvia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LB','Lebanon',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LS','Lesotho',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LR','Liberia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LY','Libyan Arab Jamahiriya',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LI','Liechtenstein',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LT','Lithuania',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LU','Luxembourg',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MO','Macao',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MK','Macedonia, The Former Yugoslav Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MG','Madagascar',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MW','Malawi',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MY','Malaysia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MV','Maldives',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ML','Mali',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MT','Malta',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MH','Marshall Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MQ','Martinique',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MR','Mauritania',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MU','Mauritius',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('YT','Mayotte',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MX','Mexico',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('FM','Micronesia, Federated States of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MD','Moldova, Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MC','Monaco',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MN','Mongolia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ME','Montenegro',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MS','Montserrat',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MA','Morocco',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MZ','Mozambique',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MM','Myanmar',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NA','Namibia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NR','Nauru',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NP','Nepal',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NL','Netherlands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AN','Netherlands Antilles',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NC','New Caledonia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NZ','New Zealand',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NI','Nicaragua',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NE','Niger',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NG','Nigeria',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NU','Niue',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NF','Norfolk Island',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MP','Northern Mariana Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('NO','Norway',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('OM','Oman',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PK','Pakistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PW','Palau',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PS','Palestinian Territory, Occupied',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PA','Panama',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PG','Papua New Guinea',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PY','Paraguay',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PE','Peru',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PH','Philippines',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PN','Pitcairn',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PL','Poland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PT','Portugal',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PR','Puerto Rico',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('QA','Qatar',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RE','Reunion',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RO','Romania',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RU','Russian Federation',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RW','Rwanda',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('BL','Saint Barthélemy',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SH','Saint Helena',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('KN','Saint Kitts and Nevis',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LC','Saint Lucia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('MF','Saint Martin',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('PM','Saint Pierre and Miquelon',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VC','Saint Vincent and the Grenadines',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('WS','Samoa',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SM','San Marino',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ST','Sao Tome and Principe',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SA','Saudi Arabia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SN','Senegal',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('RS','Serbia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SC','Seychelles',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SL','Sierra Leone',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SG','Singapore',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SK','Slovakia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SI','Slovenia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SB','Solomon Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SO','Somalia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ZA','South Africa',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GS','South Georgia and the South Sandwich Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ES','Spain',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('LK','Sri Lanka',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SD','Sudan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SR','Suriname',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SJ','Svalbard and Jan Mayen',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SZ','Swaziland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SE','Sweden',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('CH','Switzerland',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('SY','Syrian Arab Republic',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TW','Taiwan, Province Of China',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TJ','Tajikistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TZ','Tanzania, United Republic of',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TH','Thailand',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TL','Timor-Leste',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TG','Togo',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TK','Tokelau',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TO','Tonga',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TT','Trinidad and Tobago',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TN','Tunisia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TR','Turkey',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TM','Turkmenistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TC','Turks and Caicos Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('TV','Tuvalu',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UG','Uganda',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UA','Ukraine',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('AE','United Arab Emirates',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('GB','United Kingdom',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('US','United States',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UM','United States Minor Outlying Islands',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UY','Uruguay',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('UZ','Uzbekistan',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VU','Vanuatu',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VE','Venezuela',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VN','Viet Nam',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VG','Virgin Islands, British',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('VI','Virgin Islands, U.S.',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('WF','Wallis And Futuna',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('EH','Western Sahara',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('YE','Yemen',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ZM','Zambia',1,1,1);
INSERT INTO bas_cho_ccry (cry_code,cry_text1,cry_comp_fk_com,cry_active,cry_locked) VALUES ('ZW','Zimbabwe',1,1,1);

www.artenscience.co.uk
Quality Commercial Software and Custom Software Development