Programatorul de la A la ZI -> SQL

Programatorul de la A la ZI V1.2 Beta - In curand se va face lansare.

“ Indoielile noastre sunt tradatoare si ne fac sa pierdem lucrurile bune pe care altfel le-am putea castiga, din teama de a incerca. W. Shakespeare ”

sql - [2]

Tabel cu Tari - Cod Sursa

May8

Descriere

script sql pt creare tabel Tari si insert 239 tari in tabel

Cod

CREATE TABLE `Tari` (
  `country_id` mediumint(8) unsigned NOT NULL auto_increment,
  `name` varchar(64) character set utf8 collate utf8_unicode_ci NOT NULL default '''',
  PRIMARY KEY  (`country_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

INSERT INTO `Tari` VALUES (1, ''Afghanistan'');
INSERT INTO `Tari` VALUES (2, ''Albania'');
INSERT INTO `Tari` VALUES (3, ''Algeria'');
INSERT INTO `Tari` VALUES (4, ''American Samoa'');
INSERT INTO `Tari` VALUES (5, ''Andorra'');
INSERT INTO `Tari` VALUES (6, ''Angola'');
INSERT INTO `Tari` VALUES (7, ''Anguilla'');
INSERT INTO `Tari` VALUES (8, ''Antarctica'');
INSERT INTO `Tari` VALUES (9, ''Antigua and Barbuda'');
INSERT INTO `Tari` VALUES (10, ''Argentina'');
INSERT INTO `Tari` VALUES (11, ''Armenia'');
INSERT INTO `Tari` VALUES (12, ''Aruba'');
INSERT INTO `Tari` VALUES (13, ''Australia'');
INSERT INTO `Tari` VALUES (14, ''Austria'');
INSERT INTO `Tari` VALUES (15, ''Azerbaijan'');
INSERT INTO `Tari` VALUES (16, ''Bahamas'');
INSERT INTO `Tari` VALUES (17, ''Bahrain'');
INSERT INTO `Tari` VALUES (18, ''Bangladesh'');
INSERT INTO `Tari` VALUES (19, ''Barbados'');
INSERT INTO `Tari` VALUES (20, ''Belarus'');
INSERT INTO `Tari` VALUES (21, ''Belgium'');
INSERT INTO `Tari` VALUES (22, ''Belize'');
INSERT INTO `Tari` VALUES (23, ''Benin'');
INSERT INTO `Tari` VALUES (24, ''Bermuda'');
INSERT INTO `Tari` VALUES (25, ''Bhutan'');
INSERT INTO `Tari` VALUES (26, ''Bolivia'');
INSERT INTO `Tari` VALUES (27, ''Bosnia and Herzegowina'');
INSERT INTO `Tari` VALUES (28, ''Botswana'');
INSERT INTO `Tari` VALUES (29, ''Bouvet Island'');
INSERT INTO `Tari` VALUES (30, ''Brazil'');
INSERT INTO `Tari` VALUES (31, ''British Indian Ocean Territory'');
INSERT INTO `Tari` VALUES (32, ''Brunei Darussalam'');
INSERT INTO `Tari` VALUES (33, ''Bulgaria'');
INSERT INTO `Tari` VALUES (34, ''Burkina Faso'');
INSERT INTO `Tari` VALUES (35, ''Burundi'');
INSERT INTO `Tari` VALUES (36, ''Cambodia'');
INSERT INTO `Tari` VALUES (37, ''Cameroon'');
INSERT INTO `Tari` VALUES (38, ''Canada'');
INSERT INTO `Tari` VALUES (39, ''Cape Verde'');
INSERT INTO `Tari` VALUES (40, ''Cayman Islands'');
INSERT INTO `Tari` VALUES (41, ''Central African Republic'');
INSERT INTO `Tari` VALUES (42, ''Chad'');
INSERT INTO `Tari` VALUES (43, ''Chile'');
INSERT INTO `Tari` VALUES (44, ''China'');
INSERT INTO `Tari` VALUES (45, ''Christmas Island'');
INSERT INTO `Tari` VALUES (46, ''Cocos (Keeling) Islands'');
INSERT INTO `Tari` VALUES (47, ''Colombia'');
INSERT INTO `Tari` VALUES (48, ''Comoros'');
INSERT INTO `Tari` VALUES (49, ''Congo'');
INSERT INTO `Tari` VALUES (50, ''Cook Islands'');
INSERT INTO `Tari` VALUES (51, ''Costa Rica'');
INSERT INTO `Tari` VALUES (52, ''Cote D''''Ivoire'');
INSERT INTO `Tari` VALUES (53, ''Croatia'');
INSERT INTO `Tari` VALUES (54, ''Cuba'');
INSERT INTO `Tari` VALUES (55, ''Cyprus'');
INSERT INTO `Tari` VALUES (56, ''Czech Republic'');
INSERT INTO `Tari` VALUES (57, ''Denmark'');
INSERT INTO `Tari` VALUES (58, ''Djibouti'');
INSERT INTO `Tari` VALUES (59, ''Dominica'');
INSERT INTO `Tari` VALUES (60, ''Dominican Republic'');
INSERT INTO `Tari` VALUES (61, ''East Timor'');
INSERT INTO `Tari` VALUES (62, ''Ecuador'');
INSERT INTO `Tari` VALUES (63, ''Egypt'');
INSERT INTO `Tari` VALUES (64, ''El Salvador'');
INSERT INTO `Tari` VALUES (65, ''Equatorial Guinea'');
INSERT INTO `Tari` VALUES (66, ''Eritrea'');
INSERT INTO `Tari` VALUES (67, ''Estonia'');
INSERT INTO `Tari` VALUES (68, ''Ethiopia'');
INSERT INTO `Tari` VALUES (69, ''Falkland Islands (Malvinas)'');
INSERT INTO `Tari` VALUES (70, ''Faroe Islands'');
INSERT INTO `Tari` VALUES (71, ''Fiji'');
INSERT INTO `Tari` VALUES (72, ''Finland'');
INSERT INTO `Tari` VALUES (73, ''France'');
INSERT INTO `Tari` VALUES (74, ''France, Metropolitan'');
INSERT INTO `Tari` VALUES (75, ''French Guiana'');
INSERT INTO `Tari` VALUES (76, ''French Polynesia'');
INSERT INTO `Tari` VALUES (77, ''French Southern Territories'');
INSERT INTO `Tari` VALUES (78, ''Gabon'');
INSERT INTO `Tari` VALUES (79, ''Gambia'');
INSERT INTO `Tari` VALUES (80, ''Georgia'');
INSERT INTO `Tari` VALUES (81, ''Germany'');
INSERT INTO `Tari` VALUES (82, ''Ghana'');
INSERT INTO `Tari` VALUES (83, ''Gibraltar'');
INSERT INTO `Tari` VALUES (84, ''Greece'');
INSERT INTO `Tari` VALUES (85, ''Greenland'');
INSERT INTO `Tari` VALUES (86, ''Grenada'');
INSERT INTO `Tari` VALUES (87, ''Guadeloupe'');
INSERT INTO `Tari` VALUES (88, ''Guam'');
INSERT INTO `Tari` VALUES (89, ''Guatemala'');
INSERT INTO `Tari` VALUES (90, ''Guinea'');
INSERT INTO `Tari` VALUES (91, ''Guinea-bissau'');
INSERT INTO `Tari` VALUES (92, ''Guyana'');
INSERT INTO `Tari` VALUES (93, ''Haiti'');
INSERT INTO `Tari` VALUES (94, ''Heard and Mc Donald Islands'');
INSERT INTO `Tari` VALUES (95, ''Honduras'');
INSERT INTO `Tari` VALUES (96, ''Hong Kong'');
INSERT INTO `Tari` VALUES (97, ''Hungary'');
INSERT INTO `Tari` VALUES (98, ''Iceland'');
INSERT INTO `Tari` VALUES (99, ''India'');
INSERT INTO `Tari` VALUES (100, ''Indonesia'');
INSERT INTO `Tari` VALUES (101, ''Iran (Islamic Republic of)'');
INSERT INTO `Tari` VALUES (102, ''Iraq'');
INSERT INTO `Tari` VALUES (103, ''Ireland'');
INSERT INTO `Tari` VALUES (104, ''Israel'');
INSERT INTO `Tari` VALUES (105, ''Italy'');
INSERT INTO `Tari` VALUES (106, ''Jamaica'');
INSERT INTO `Tari` VALUES (107, ''Japan'');
INSERT INTO `Tari` VALUES (108, ''Jordan'');
INSERT INTO `Tari` VALUES (109, ''Kazakhstan'');
INSERT INTO `Tari` VALUES (110, ''Kenya'');
INSERT INTO `Tari` VALUES (111, ''Kiribati'');
INSERT INTO `Tari` VALUES (112, ''Korea, Democratic People''''s Republic of'');
INSERT INTO `Tari` VALUES (113, ''Korea, Republic of'');
INSERT INTO `Tari` VALUES (114, ''Kuwait'');
INSERT INTO `Tari` VALUES (115, ''Kyrgyzstan'');
INSERT INTO `Tari` VALUES (116, ''Lao People''''s Democratic Republic'');
INSERT INTO `Tari` VALUES (117, ''Latvia'');
INSERT INTO `Tari` VALUES (118, ''Lebanon'');
INSERT INTO `Tari` VALUES (119, ''Lesotho'');
INSERT INTO `Tari` VALUES (120, ''Liberia'');
INSERT INTO `Tari` VALUES (121, ''Libyan Arab Jamahiriya'');
INSERT INTO `Tari` VALUES (122, ''Liechtenstein'');
INSERT INTO `Tari` VALUES (123, ''Lithuania'');
INSERT INTO `Tari` VALUES (124, ''Luxembourg'');
INSERT INTO `Tari` VALUES (125, ''Macau'');
INSERT INTO `Tari` VALUES (126, ''Macedonia, The Former Yugoslav Republic of'');
INSERT INTO `Tari` VALUES (127, ''Madagascar'');
INSERT INTO `Tari` VALUES (128, ''Malawi'');
INSERT INTO `Tari` VALUES (129, ''Malaysia'');
INSERT INTO `Tari` VALUES (130, ''Maldives'');
INSERT INTO `Tari` VALUES (131, ''Mali'');
INSERT INTO `Tari` VALUES (132, ''Malta'');
INSERT INTO `Tari` VALUES (133, ''Marshall Islands'');
INSERT INTO `Tari` VALUES (134, ''Martinique'');
INSERT INTO `Tari` VALUES (135, ''Mauritania'');
INSERT INTO `Tari` VALUES (136, ''Mauritius'');
INSERT INTO `Tari` VALUES (137, ''Mayotte'');
INSERT INTO `Tari` VALUES (138, ''Mexico'');
INSERT INTO `Tari` VALUES (139, ''Micronesia, Federated States of'');
INSERT INTO `Tari` VALUES (140, ''Moldova, Republic of'');
INSERT INTO `Tari` VALUES (141, ''Monaco'');
INSERT INTO `Tari` VALUES (142, ''Mongolia'');
INSERT INTO `Tari` VALUES (143, ''Montserrat'');
INSERT INTO `Tari` VALUES (144, ''Morocco'');
INSERT INTO `Tari` VALUES (145, ''Mozambique'');
INSERT INTO `Tari` VALUES (146, ''Myanmar'');
INSERT INTO `Tari` VALUES (147, ''Namibia'');
INSERT INTO `Tari` VALUES (148, ''Nauru'');
INSERT INTO `Tari` VALUES (149, ''Nepal'');
INSERT INTO `Tari` VALUES (150, ''Netherlands'');
INSERT INTO `Tari` VALUES (151, ''Netherlands Antilles'');
INSERT INTO `Tari` VALUES (152, ''New Caledonia'');
INSERT INTO `Tari` VALUES (153, ''New Zealand'');
INSERT INTO `Tari` VALUES (154, ''Nicaragua'');
INSERT INTO `Tari` VALUES (155, ''Niger'');
INSERT INTO `Tari` VALUES (156, ''Nigeria'');
INSERT INTO `Tari` VALUES (157, ''Niue'');
INSERT INTO `Tari` VALUES (158, ''Norfolk Island'');
INSERT INTO `Tari` VALUES (159, ''Northern Mariana Islands'');
INSERT INTO `Tari` VALUES (160, ''Norway'');
INSERT INTO `Tari` VALUES (161, ''Oman'');
INSERT INTO `Tari` VALUES (162, ''Pakistan'');
INSERT INTO `Tari` VALUES (163, ''Palau'');
INSERT INTO `Tari` VALUES (164, ''Panama'');
INSERT INTO `Tari` VALUES (165, ''Papua New Guinea'');
INSERT INTO `Tari` VALUES (166, ''Paraguay'');
INSERT INTO `Tari` VALUES (167, ''Peru'');
INSERT INTO `Tari` VALUES (168, ''Philippines'');
INSERT INTO `Tari` VALUES (169, ''Pitcairn'');
INSERT INTO `Tari` VALUES (170, ''Poland'');
INSERT INTO `Tari` VALUES (171, ''Portugal'');
INSERT INTO `Tari` VALUES (172, ''Puerto Rico'');
INSERT INTO `Tari` VALUES (173, ''Qatar'');
INSERT INTO `Tari` VALUES (174, ''Reunion'');
INSERT INTO `Tari` VALUES (175, ''Romania'');
INSERT INTO `Tari` VALUES (176, ''Russian Federation'');
INSERT INTO `Tari` VALUES (177, ''Rwanda'');
INSERT INTO `Tari` VALUES (178, ''Saint Kitts and Nevis'');
INSERT INTO `Tari` VALUES (179, ''Saint Lucia'');
INSERT INTO `Tari` VALUES (180, ''Saint Vincent and the Grenadines'');
INSERT INTO `Tari` VALUES (181, ''Samoa'');
INSERT INTO `Tari` VALUES (182, ''San Marino'');
INSERT INTO `Tari` VALUES (183, ''Sao Tome and Principe'');
INSERT INTO `Tari` VALUES (184, ''Saudi Arabia'');
INSERT INTO `Tari` VALUES (185, ''Senegal'');
INSERT INTO `Tari` VALUES (186, ''Seychelles'');
INSERT INTO `Tari` VALUES (187, ''Sierra Leone'');
INSERT INTO `Tari` VALUES (188, ''Singapore'');
INSERT INTO `Tari` VALUES (189, ''Slovakia (Slovak Republic)'');
INSERT INTO `Tari` VALUES (190, ''Slovenia'');
INSERT INTO `Tari` VALUES (191, ''Solomon Islands'');
INSERT INTO `Tari` VALUES (192, ''Somalia'');
INSERT INTO `Tari` VALUES (193, ''South Africa'');
INSERT INTO `Tari` VALUES (194, ''South Georgia and the South Sandwich Islands'');
INSERT INTO `Tari` VALUES (195, ''Spain'');
INSERT INTO `Tari` VALUES (196, ''Sri Lanka'');
INSERT INTO `Tari` VALUES (197, ''St. Helena'');
INSERT INTO `Tari` VALUES (198, ''St. Pierre and Miquelon'');
INSERT INTO `Tari` VALUES (199, ''Sudan'');
INSERT INTO `Tari` VALUES (200, ''Suriname'');
INSERT INTO `Tari` VALUES (201, ''Svalbard and Jan Mayen Islands'');
INSERT INTO `Tari` VALUES (202, ''Swaziland'');
INSERT INTO `Tari` VALUES (203, ''Sweden'');
INSERT INTO `Tari` VALUES (204, ''Switzerland'');
INSERT INTO `Tari` VALUES (205, ''Syrian Arab Republic'');
INSERT INTO `Tari` VALUES (206, ''Taiwan'');
INSERT INTO `Tari` VALUES (207, ''Tajikistan'');
INSERT INTO `Tari` VALUES (208, ''Tanzania, United Republic of'');
INSERT INTO `Tari` VALUES (209, ''Thailand'');
INSERT INTO `Tari` VALUES (210, ''Togo'');
INSERT INTO `Tari` VALUES (211, ''Tokelau'');
INSERT INTO `Tari` VALUES (212, ''Tonga'');
INSERT INTO `Tari` VALUES (213, ''Trinidad and Tobago'');
INSERT INTO `Tari` VALUES (214, ''Tunisia'');
INSERT INTO `Tari` VALUES (215, ''Turkey'');
INSERT INTO `Tari` VALUES (216, ''Turkmenistan'');
INSERT INTO `Tari` VALUES (217, ''Turks and Caicos Islands'');
INSERT INTO `Tari` VALUES (218, ''Tuvalu'');
INSERT INTO `Tari` VALUES (219, ''Uganda'');
INSERT INTO `Tari` VALUES (220, ''Ukraine'');
INSERT INTO `Tari` VALUES (221, ''United Arab Emirates'');
INSERT INTO `Tari` VALUES (222, ''United Kingdom'');
INSERT INTO `Tari` VALUES (223, ''United States'');
INSERT INTO `Tari` VALUES (224, ''United States Minor Outlying Islands'');
INSERT INTO `Tari` VALUES (225, ''Uruguay'');
INSERT INTO `Tari` VALUES (226, ''Uzbekistan'');
INSERT INTO `Tari` VALUES (227, ''Vanuatu'');
INSERT INTO `Tari` VALUES (228, ''Vatican City State (Holy See)'');
INSERT INTO `Tari` VALUES (229, ''Venezuela'');
INSERT INTO `Tari` VALUES (230, ''Viet Nam'');
INSERT INTO `Tari` VALUES (231, ''Virgin Islands (British)'');
INSERT INTO `Tari` VALUES (232, ''Virgin Islands (U.S.)'');
INSERT INTO `Tari` VALUES (233, ''Wallis and Futuna Islands'');
INSERT INTO `Tari` VALUES (234, ''Western Sahara'');
INSERT INTO `Tari` VALUES (235, ''Yemen'');
INSERT INTO `Tari` VALUES (236, ''Yugoslavia'');
INSERT INTO `Tari` VALUES (237, ''Zaire'');
INSERT INTO `Tari` VALUES (238, ''Zambia'');
INSERT INTO `Tari` VALUES (239, ''Zimbabwe'');

V1.2 Beta - In curand se va face lansare.

Copyright 2007 � . Toate drepturile rezervate .