Teacher SiliconIndia replied to Arun Desai Friday, November 27, 2009
Hi arun desai,
Execute the below query in your system
CREATE DATABASE countrycodes;
use countrycodes;
CREATE TABLE countrycodes (code CHAR(2),country text);
insert into countrycodes (code,country) values ('AF','Afghanistan');
insert into countrycodes (code,country) values ('AL','Albania');
insert into countrycodes (code,country) values ('DZ','Algeria');
insert into countrycodes (code,country) values ('AS','American Samoa');
insert into countrycodes (code,country) values ('AD','Andorra');
insert into countrycodes (code,country) values ('AO','Angola');
insert into countrycodes (code,country) values ('AI','Anguilla');
insert into countrycodes (code,country) values ('AQ','Antarctica');
insert into countrycodes (code,country) values ('AG','Antigua and Barbuda');
insert into countrycodes (code,country) values ('AR','Argentina');
insert into countrycodes (code,country) values ('AM','Armenia');
insert into countrycodes (code,country) values ('AW','Aruba');
insert into countrycodes (code,country) values ('AU','Australia');
insert into countrycodes (code,country) values ('AT','Austria');
insert into countrycodes (code,country) values ('AZ','Azerbaidjan');
insert into countrycodes (code,country) values ('BS','Bahamas');
insert into countrycodes (code,country) values ('BH','Bahrain');
insert into countrycodes (code,country) values ('BD','Banglades');
insert into countrycodes (code,country) values ('BB','Barbados');
insert into countrycodes (code,country) values ('BY','Belarus');
insert into countrycodes (code,country) values ('BE','Belgium');
insert into countrycodes (code,country) values ('BZ','Belize');
insert into countrycodes (code,country) values ('BJ','Benin');
insert into countrycodes (code,country) values ('BM','Bermuda');
insert into countrycodes (code,country) values ('BO','Bolivia');
insert into countrycodes (code,country) values ('BA','Bosnia-Herzegovina');
insert into countrycodes (code,country) values ('BW','Botswana');
insert into countrycodes (code,country) values ('BV','Bouvet Island');
insert into countrycodes (code,country) values ('BR','Brazil');
insert into countrycodes (code,country) values ('IO','British Indian O. Terr.');
insert into countrycodes (code,country) values ('BN','Brunei Darussalam');
insert into countrycodes (code,country) values ('BG','Bulgaria');
insert into countrycodes (code,country) values ('BF','Burkina Faso');
insert into countrycodes (code,country) values ('BI','Burundi');
insert into countrycodes (code,country) values ('BT','Buthan');
insert into countrycodes (code,country) values ('KH','Cambodia');
insert into countrycodes (code,country) values ('CM','Cameroon');
insert into countrycodes (code,country) values ('CA','Canada');
insert into countrycodes (code,country) values ('CV','Cape Verde');
insert into countrycodes (code,country) values ('KY','Cayman Islands');
insert into countrycodes (code,country) values ('CF','Central African Rep.');
insert into countrycodes (code,country) values ('TD','Chad');
insert into countrycodes (code,country) values ('CL','Chile');
insert into countrycodes (code,country) values ('CN','China');
insert into countrycodes (code,country) values ('CX','Christmas Island');
insert into countrycodes (code,country) values ('CC','Cocos (Keeling) Isl.');
insert into countrycodes (code,country) values ('CO','Colombia');
insert into countrycodes (code,country) values ('KM','Comoros');
insert into countrycodes (code,country) values ('CG','Congo');
insert into countrycodes (code,country) values ('CK','Cook Islands');
insert into countrycodes (code,country) values ('CR','Costa Rica');
insert into countrycodes (code,country) values ('HR','Croatia');
insert into countrycodes (code,country) values ('CU','Cuba');
insert into countrycodes (code,country) values ('CY','Cyprus');
insert into countrycodes (code,country) values ('CZ','Czech Republic');
insert into countrycodes (code,country) values ('CS','Czechoslovakia');
insert into countrycodes (code,country) values ('DK','Denmark');
insert into countrycodes (code,country) values ('DJ','Djibouti');
insert into countrycodes (code,country) values ('DM','Dominica');
insert into countrycodes (code,country) values ('DO','Dominican Republic');
insert into countrycodes (code,country) values ('TP','East Timor');
insert into countrycodes (code,country) values ('EC','Ecuador');
insert into countrycodes (code,country) values ('EG','Egypt');
insert into countrycodes (code,country) values ('SV','El Salvador');
insert into countrycodes (code,country) values ('GQ','Equatorial Guinea');
insert into countrycodes (code,country) values ('EE','Estonia');
insert into countrycodes (code,country) values ('ET','Ethiopia');
insert into countrycodes (code,country) values ('FK','Falkland Isl.(UK)');
insert into countrycodes (code,country) values ('FO','Faroe Islands');
insert into countrycodes (code,country) values ('FJ','Fiji');
insert into countrycodes (code,country) values ('FI','Finland');
insert into countrycodes (code,country) values ('FR','France');
insert into countrycodes (code,country) values ('FX','France (European Ter.)');
insert into countrycodes (code,country) values ('TF','French Southern Terr.');
insert into countrycodes (code,country) values ('GA','Gabon');
insert into countrycodes (code,country) values ('GM','Gambia');
insert into countrycodes (code,country) values ('GE','Georgia');
insert into countrycodes (code,country) values ('DE','Germany');
insert into countrycodes (code,country) values ('GH','Ghana');
insert into countrycodes (code,country) values ('GI','Gibraltar');
insert into countrycodes (code,country) values ('GB','Great Britain (UK)');
insert into countrycodes (code,country) values ('GR','Greece');
insert into countrycodes (code,country) values ('GL','Greenland');
insert into countrycodes (code,country) values ('GD','Grenada');
insert into countrycodes (code,country) values ('GP','Guadeloupe (Fr.)');
insert into countrycodes (code,country) values ('GU','Guam (US)');
insert into countrycodes (code,country) values ('GT','Guatemala');
insert into countrycodes (code,country) values ('GN','Guinea');
insert into countrycodes (code,country) values ('GW','Guinea Bissau');
insert into countrycodes (code,country) values ('GY','Guyana');
insert into countrycodes (code,country) values ('GF','Guyana (Fr.)');
insert into countrycodes (code,country) values ('HT','Haiti');
insert into countrycodes (code,country) values ('HM','Heard & McDonald Isl.');
insert into countrycodes (code,country) values ('HN','Honduras');
insert into countrycodes (code,country) values ('HK','Hong Kong');
insert into countrycodes (code,country) values ('HU','Hungary');
insert into countrycodes (code,country) values ('IS','Iceland');
insert into countrycodes (code,country) values ('IN','India');
insert into countrycodes (code,country) values ('ID','Indonesia');
insert into countrycodes (code,country) values ('IR','Iran');
insert into countrycodes (code,country) values ('IQ','Iraq');
insert into countrycodes (code,country) values ('IE','Ireland');
insert into countrycodes (code,country) values ('IL','Israel');
insert into countrycodes (code,country) values ('IT','Italy');
insert into countrycodes (code,country) values ('CI','Ivory Coast');
insert into countrycodes (code,country) values ('JM','Jamaica');
insert into countrycodes (code,country) values ('JP','Japan');
insert into countrycodes (code,country) values ('JO','Jordan');
insert into countrycodes (code,country) values ('KZ','Kazachstan');
insert into countrycodes (code,country) values ('KE','Kenya');
insert into countrycodes (code,country) values ('KG','Kirgistan');
insert into countrycodes (code,country) values ('KI','Kiribati');
insert into countrycodes (code,country) values ('KP','Korea (North)');
insert into countrycodes (code,country) values ('KR','Korea (South)');
insert into countrycodes (code,country) values ('KW','Kuwait');
insert into countrycodes (code,country) values ('LA','Laos');
insert into countrycodes (code,country) values ('LV','Latvia');
insert into countrycodes (code,country) values ('LB','Lebanon');
insert into countrycodes (code,country) values ('LS','Lesotho');
insert into countrycodes (code,country) values ('LR','Liberia');
insert into countrycodes (code,country) values ('LY','Libya');
insert into countrycodes (code,country) values ('LI','Liechtenstein');
insert into countrycodes (code,country) values ('LT','Lithuania');
insert into countrycodes (code,country) values ('LU','Luxembourg');
insert into countrycodes (code,country) values ('MO','Macau');
insert into countrycodes (code,country) values ('MG','Madagascar');
insert into countrycodes (code,country) values ('MW','Malawi');
insert into countrycodes (code,country) values ('MY','Malaysia');
insert into countrycodes (code,country) values ('MV','Maldives');
insert into countrycodes (code,country) values ('ML','Mali');
insert into countrycodes (code,country) values ('MT','Malta');
insert into countrycodes (code,country) values ('MH','Marshall Islands');
insert into countrycodes (code,country) values ('MQ','Martinique (Fr.)');
insert into countrycodes (code,country) values ('MR','Mauritania');
insert into countrycodes (code,country) values ('MU','Mauritius');
insert into countrycodes (code,country) values ('MX','Mexico');
insert into countrycodes (code
