PHP Classes

File: Database.txt

Recommend this page to a friend!
  Classes of Bala   MySQL Wrapper class   Database.txt   Download  
File: Database.txt
Role: Auxiliary data
Content type: text/plain
Description: sample database
Class: MySQL Wrapper class
Execute MySQL queries defined programmatically
Author: By
Last change:
Date: 14 years ago
Size: 16,271 bytes
 

Contents

Class file image Download
/* SQLyog Community Edition- MySQL GUI v7.02 MySQL - 5.1.41 : Database - test ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`test` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `test`; /*Table structure for table `country` */ DROP TABLE IF EXISTS `country`; CREATE TABLE `country` ( `id` int(11) NOT NULL AUTO_INCREMENT, `Code` char(3) NOT NULL, `Name` char(52) NOT NULL DEFAULT '', `Continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL DEFAULT 'Asia', `SurfaceArea` float(10,2) NOT NULL DEFAULT '0.00', `Population` int(11) NOT NULL DEFAULT '0', `LocalName` char(45) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1004 DEFAULT CHARSET=latin1; /*Data for the table `country` */ insert into `country`(`id`,`Code`,`Name`,`Continent`,`SurfaceArea`,`Population`,`LocalName`) values (18,'XYZ','Bahrain','Asia',694.00,617000,'Al-Bahrayn'),(19,'XYZ','Bangladesh','Asia',143998.00,129155000,'Bangladesh'),(251,'XYZ','','Asia',0.00,0,''),(21,'XYZ','Belgium','Europe',30518.00,10239000,'België/Belgique'),(22,'XYZ','Belize','North America',22696.00,241000,'Belize'),(248,'XYZ','','Asia',0.00,0,''),(24,'XYZ','Bermuda','North America',53.00,65000,'Bermuda'),(25,'XYZ','Bhutan','Asia',47000.00,2124000,'Druk-Yul'),(26,'XYZ','Bolivia','South America',1098581.00,8329000,'Bolivia'),(27,'XYZ','Bosnia and Herzegovina','Europe',51197.00,3972000,'Bosna i Hercegovina'),(28,'XYZ','Botswana','Africa',581730.00,1622000,'Botswana'),(29,'XYZ','Brazil','South America',8547403.00,170115000,'Brasil'),(30,'XYZ','United Kingdom','Europe',242900.00,59623400,'United Kingdom'),(31,'XYZ','Virgin Islands, British','North America',151.00,21000,'British Virgin Islands'),(32,'XYZ','Brunei','Asia',5765.00,328000,'Brunei Darussalam'),(33,'XYZ','Bulgaria','Europe',110994.00,8190900,'Balgarija'),(34,'XYZ','Burkina Faso','Africa',274000.00,11937000,'Burkina Faso'),(35,'XYZ','Burundi','Africa',27834.00,6695000,'Burundi/Uburundi'),(36,'XYZ','Cayman Islands','North America',264.00,38000,'Cayman Islands'),(37,'XYZ','Chile','South America',756626.00,15211000,'Chile'),(38,'XYZ','Cook Islands','Oceania',236.00,20000,'The Cook Islands'),(39,'XYZ','Costa Rica','North America',51100.00,4023000,'Costa Rica'),(40,'XYZ','Djibouti','Africa',23200.00,638000,'Djibouti/Jibuti'),(41,'XYZ','Dominica','North America',751.00,71000,'Dominica'),(42,'XYZ','Dominican Republic','North America',48511.00,8495000,'República Dominicana'),(43,'XYZ','Ecuador','South America',283561.00,12646000,'Ecuador'),(44,'XYZ','Egypt','Africa',1001449.00,68470000,'Misr'),(45,'XYZ','El Salvador','North America',21041.00,6276000,'El Salvador'),(46,'XYZ','Eritrea','Africa',117600.00,3850000,'Ertra'),(47,'XYZ','Spain','Europe',505992.00,39441700,'España'),(48,'XYZ','South Africa','Africa',1221037.00,40377000,'South Africa'),(49,'XYZ','Ethiopia','Africa',1104300.00,62565000,'YeItyop´iya'),(50,'XYZ','Falkland Islands','South America',12173.00,2000,'Falkland Islands'),(51,'XYZ','Fiji Islands','Oceania',18274.00,817000,'Fiji Islands'),(52,'XYZ','Philippines','Asia',300000.00,75967000,'Pilipinas'),(53,'XYZ','Faroe Islands','Europe',1399.00,43000,'Føroyar'),(54,'XYZ','Gabon','Africa',267668.00,1226000,'Le Gabon'),(55,'XYZ','Gambia','Africa',11295.00,1305000,'The Gambia'),(56,'XYZ','Georgia','Asia',69700.00,4968000,'Sakartvelo'),(57,'XYZ','Ghana','Africa',238533.00,20212000,'Ghana'),(58,'XYZ','Gibraltar','Europe',6.00,25000,'Gibraltar'),(59,'XYZ','Grenada','North America',344.00,94000,'Grenada'),(60,'XYZ','Greenland','North America',2166090.00,56000,'Kalaallit Nunaat/Grønland'),(61,'XYZ','Guadeloupe','North America',1705.00,456000,'Guadeloupe'),(62,'XYZ','Guam','Oceania',549.00,168000,'Guam'),(63,'XYZ','Guatemala','North America',108889.00,11385000,'Guatemala'),(64,'XYZ','Guinea','Africa',245857.00,7430000,'Guinée'),(65,'XYZ','Guinea-Bissau','Africa',36125.00,1213000,'Guiné-Bissau'),(66,'XYZ','Guyana','South America',214969.00,861000,'Guyana'),(67,'XYZ','Haiti','North America',27750.00,8222000,'Haïti/Dayti'),(68,'XYZ','Honduras','North America',112088.00,6485000,'Honduras'),(69,'XYZ','Hong Kong','Asia',1075.00,6782000,'Xianggang/Hong Kong'),(70,'XYZ','Svalbard and Jan Mayen','Europe',62422.00,3200,'Svalbard og Jan Mayen'),(71,'XYZ','Indonesia','Asia',1904569.00,212107000,'Indonesia'),(72,'XYZ','India','Asia',3287263.00,1013662000,'Bharat/India'),(73,'XYZ','Iraq','Asia',438317.00,23115000,'Al-´Iraq'),(74,'XYZ','Iran','Asia',1648195.00,67702000,'Iran'),(75,'XYZ','Ireland','Europe',70273.00,3775100,'Ireland/Éire'),(76,'XYZ','Iceland','Europe',103000.00,279000,'Ísland'),(77,'XYZ','Israel','Asia',21056.00,6217000,'Yisra’el/Isra’il'),(78,'XYZ','Italy','Europe',301316.00,57680000,'Italia'),(79,'XYZ','East Timor','Asia',14874.00,885000,'Timor Timur'),(80,'XYZ','Austria','Europe',83859.00,8091800,'Österreich'),(81,'XYZ','Jamaica','North America',10990.00,2583000,'Jamaica'),(82,'XYZ','Japan','Asia',377829.00,126714000,'Nihon/Nippon'),(83,'XYZ','Yemen','Asia',527968.00,18112000,'Al-Yaman'),(84,'XYZ','Jordan','Asia',88946.00,5083000,'Al-Urdunn'),(85,'XYZ','Christmas Island','Oceania',135.00,2500,'Christmas Island'),(86,'XYZ','Yugoslavia','Europe',102173.00,10640000,'Jugoslavija'),(87,'XYZ','Cambodia','Asia',181035.00,11168000,'Kâmpuchéa'),(88,'XYZ','Cameroon','Africa',475442.00,15085000,'Cameroun/Cameroon'),(89,'XYZ','Canada','North America',9970610.00,31147000,'Canada'),(90,'XYZ','Cape Verde','Africa',4033.00,428000,'Cabo Verde'),(91,'XYZ','Kazakstan','Asia',2724900.00,16223000,'Qazaqstan'),(92,'XYZ','Kenya','Africa',580367.00,30080000,'Kenya'),(93,'XYZ','Central African Republic','Africa',622984.00,3615000,'Centrafrique/Bê-Afrîka'),(94,'XYZ','China','Asia',9572900.00,1277558000,'Zhongquo'),(95,'XYZ','Kyrgyzstan','Asia',199900.00,4699000,'Kyrgyzstan'),(96,'XYZ','Kiribati','Oceania',726.00,83000,'Kiribati'),(97,'XYZ','Colombia','South America',1138914.00,42321000,'Colombia'),(98,'XYZ','Comoros','Africa',1862.00,578000,'Komori/Comores'),(99,'XYZ','Congo','Africa',342000.00,2943000,'Congo'),(100,'XYZ','Congo, The Democratic Republic of the','Africa',2344858.00,51654000,'République Démocratique du Congo'),(101,'XYZ','Cocos (Keeling) Islands','Oceania',14.00,600,'Cocos (Keeling) Islands'),(102,'XYZ','North Korea','Asia',120538.00,24039000,'Choson Minjujuui In´min Konghwaguk (Bukhan)'),(103,'XYZ','South Korea','Asia',99434.00,46844000,'Taehan Min’guk (Namhan)'),(104,'XYZ','Greece','Europe',131626.00,10545700,'Elláda'),(105,'XYZ','Croatia','Europe',56538.00,4473000,'Hrvatska'),(106,'XYZ','Cuba','North America',110861.00,11201000,'Cuba'),(107,'XYZ','Kuwait','Asia',17818.00,1972000,'Al-Kuwayt'),(108,'XYZ','Cyprus','Asia',9251.00,754700,'Kýpros/Kibris'),(109,'XYZ','Laos','Asia',236800.00,5433000,'Lao'),(110,'XYZ','Latvia','Europe',64589.00,2424200,'Latvija'),(111,'XYZ','Lesotho','Africa',30355.00,2153000,'Lesotho'),(112,'XYZ','Lebanon','Asia',10400.00,3282000,'Lubnan'),(113,'XYZ','Liberia','Africa',111369.00,3154000,'Liberia'),(114,'XYZ','Libyan Arab Jamahiriya','Africa',1759540.00,5605000,'Libiya'),(115,'XYZ','Liechtenstein','Europe',160.00,32300,'Liechtenstein'),(116,'XYZ','Lithuania','Europe',65301.00,3698500,'Lietuva'),(117,'XYZ','Luxembourg','Europe',2586.00,435700,'Luxembourg/Lëtzebuerg'),(118,'XYZ','Western Sahara','Africa',266000.00,293000,'As-Sahrawiya'),(119,'XYZ','Macao','Asia',18.00,473000,'Macau/Aomen'),(120,'XYZ','Madagascar','Africa',587041.00,15942000,'Madagasikara/Madagascar'),(121,'XYZ','Macedonia','Europe',25713.00,2024000,'Makedonija'),(122,'XYZ','Malawi','Africa',118484.00,10925000,'Malawi'),(123,'XYZ','Maldives','Asia',298.00,286000,'Dhivehi Raajje/Maldives'),(124,'XYZ','Malaysia','Asia',329758.00,22244000,'Malaysia'),(125,'XYZ','Mali','Africa',1240192.00,11234000,'Mali'),(126,'XYZ','Malta','Europe',316.00,380200,'Malta'),(127,'XYZ','Morocco','Africa',446550.00,28351000,'Al-Maghrib'),(128,'XYZ','Marshall Islands','Oceania',181.00,64000,'Marshall Islands/Majol'),(129,'XYZ','Martinique','North America',1102.00,395000,'Martinique'),(130,'XYZ','Mauritania','Africa',1025520.00,2670000,'Muritaniya/Mauritanie'),(131,'XYZ','Mauritius','Africa',2040.00,1158000,'Mauritius'),(132,'XYZ','Mayotte','Africa',373.00,149000,'Mayotte'),(133,'XYZ','Mexico','North America',1958201.00,98881000,'México'),(134,'XYZ','Micronesia, Federated States of','Oceania',702.00,119000,'Micronesia'),(135,'XYZ','Moldova','Europe',33851.00,4380000,'Moldova'),(136,'XYZ','Monaco','Europe',1.50,34000,'Monaco'),(137,'XYZ','Mongolia','Asia',1566500.00,2662000,'Mongol Uls'),(138,'XYZ','Montserrat','North America',102.00,11000,'Montserrat'),(139,'XYZ','Mozambique','Africa',801590.00,19680000,'Moçambique'),(140,'XYZ','Myanmar','Asia',676578.00,45611000,'Myanma Pye'),(141,'XYZ','Namibia','Africa',824292.00,1726000,'Namibia'),(142,'XYZ','Nauru','Oceania',21.00,12000,'Naoero/Nauru'),(143,'XYZ','Nepal','Asia',147181.00,23930000,'Nepal'),(144,'XYZ','Nicaragua','North America',130000.00,5074000,'Nicaragua'),(145,'XYZ','Niger','Africa',1267000.00,10730000,'Niger'),(146,'XYZ','Nigeria','Africa',923768.00,111506000,'Nigeria'),(147,'XYZ','Niue','Oceania',260.00,2000,'Niue'),(148,'XYZ','Norfolk Island','Oceania',36.00,2000,'Norfolk Island'),(149,'XYZ','Norway','Europe',323877.00,4478500,'Norge'),(150,'XYZ','Côte d’Ivoire','Africa',322463.00,14786000,'Côte d’Ivoire'),(151,'XYZ','Oman','Asia',309500.00,2542000,'´Uman'),(152,'XYZ','Pakistan','Asia',796095.00,156483000,'Pakistan'),(153,'XYZ','Palau','Oceania',459.00,19000,'Belau/Palau'),(154,'XYZ','Panama','North America',75517.00,2856000,'Panamá'),(155,'XYZ','Papua New Guinea','Oceania',462840.00,4807000,'Papua New Guinea/Papua Niugini'),(156,'XYZ','Paraguay','South America',406752.00,5496000,'Paraguay'),(157,'XYZ','Peru','South America',1285216.00,25662000,'Perú/Piruw'),(159,'XYZ','Northern Mariana Islands','Oceania',464.00,78000,'Northern Mariana Islands'),(160,'XYZ','Portugal','Europe',91982.00,9997600,'Portugal'),(161,'XYZ','Puerto Rico','North America',8875.00,3869000,'Puerto Rico'),(162,'XYZ','Poland','Europe',323250.00,38653600,'Polska'),(163,'XYZ','Equatorial Guinea','Africa',28051.00,453000,'Guinea Ecuatorial'),(164,'XYZ','Qatar','Asia',11000.00,599000,'Qatar'),(165,'XYZ','France','Europe',551500.00,59225700,'France'),(166,'XYZ','French Guiana','South America',90000.00,181000,'Guyane française'),(167,'XYZ','French Polynesia','Oceania',4000.00,235000,'Polynésie française'),(168,'XYZ','Réunion','Africa',2510.00,699000,'Réunion'),(169,'XYZ','Romania','Europe',238391.00,22455500,'România'),(170,'XYZ','Rwanda','Africa',26338.00,7733000,'Rwanda/Urwanda'),(171,'XYZ','Sweden','Europe',449964.00,8861400,'Sverige'),(172,'XYZ','Saint Helena','Africa',314.00,6000,'Saint Helena'),(173,'XYZ','Saint Kitts and Nevis','North America',261.00,38000,'Saint Kitts and Nevis'),(174,'XYZ','Saint Lucia','North America',622.00,154000,'Saint Lucia'),(175,'XYZ','Saint Vincent and the Grenadines','North America',388.00,114000,'Saint Vincent and the Grenadines'),(176,'XYZ','Saint Pierre and Miquelon','North America',242.00,7000,'Saint-Pierre-et-Miquelon'),(177,'XYZ','Germany','Europe',357022.00,82164700,'Deutschland'),(178,'XYZ','Solomon Islands','Oceania',28896.00,444000,'Solomon Islands'),(179,'XYZ','Zambia','Africa',752618.00,9169000,'Zambia'),(180,'XYZ','Samoa','Oceania',2831.00,180000,'Samoa'),(181,'XYZ','San Marino','Europe',61.00,27000,'San Marino'),(182,'XYZ','Sao Tome and Principe','Africa',964.00,147000,'São Tomé e Príncipe'),(183,'XYZ','Saudi Arabia','Asia',2149690.00,21607000,'Al-´Arabiya as-Sa´udiya'),(184,'XYZ','Senegal','Africa',196722.00,9481000,'Sénégal/Sounougal'),(185,'XYZ','Seychelles','Africa',455.00,77000,'Sesel/Seychelles'),(186,'XYZ','Sierra Leone','Africa',71740.00,4854000,'Sierra Leone'),(187,'XYZ','Singapore','Asia',618.00,3567000,'Singapore/Singapura/Xinjiapo/Singapur'),(188,'XYZ','Slovakia','Europe',49012.00,5398700,'Slovensko'),(189,'XYZ','Slovenia','Europe',20256.00,1987800,'Slovenija'),(190,'XYZ','Somalia','Africa',637657.00,10097000,'Soomaaliya'),(191,'XYZ','Sri Lanka','Asia',65610.00,18827000,'Sri Lanka/Ilankai'),(192,'XYZ','Sudan','Africa',2505813.00,29490000,'As-Sudan'),(193,'XYZ','Finland','Europe',338145.00,5171300,'Suomi'),(194,'XYZ','Suriname','South America',163265.00,417000,'Suriname'),(195,'XYZ','Swaziland','Africa',17364.00,1008000,'kaNgwane'),(196,'XYZ','Switzerland','Europe',41284.00,7160400,'Schweiz/Suisse/Svizzera/Svizra'),(197,'XYZ','Syria','Asia',185180.00,16125000,'Suriya'),(198,'XYZ','Tajikistan','Asia',143100.00,6188000,'Toçikiston'),(199,'XYZ','Taiwan','Asia',36188.00,22256000,'T’ai-wan'),(200,'XYZ','Tanzania','Africa',883749.00,33517000,'Tanzania'),(201,'XYZ','Denmark','Europe',43094.00,5330000,'Danmark'),(202,'XYZ','Thailand','Asia',513115.00,61399000,'Prathet Thai'),(203,'XYZ','Togo','Africa',56785.00,4629000,'Togo'),(204,'XYZ','Tokelau','Oceania',12.00,2000,'Tokelau'),(205,'XYZ','Tonga','Oceania',650.00,99000,'Tonga'),(206,'XYZ','Trinidad and Tobago','North America',5130.00,1295000,'Trinidad and Tobago'),(207,'XYZ','Chad','Africa',1284000.00,7651000,'Tchad/Tshad'),(208,'XYZ','Czech Republic','Europe',78866.00,10278100,'¸esko'),(209,'XYZ','Tunisia','Africa',163610.00,9586000,'Tunis/Tunisie'),(210,'XYZ','Turkey','Asia',774815.00,66591000,'Türkiye'),(211,'XYZ','Turkmenistan','Asia',488100.00,4459000,'Türkmenostan'),(212,'XYZ','Turks and Caicos Islands','North America',430.00,17000,'The Turks and Caicos Islands'),(213,'XYZ','Tuvalu','Oceania',26.00,12000,'Tuvalu'),(214,'XYZ','Uganda','Africa',241038.00,21778000,'Uganda'),(215,'XYZ','Ukraine','Europe',603700.00,50456000,'Ukrajina'),(216,'XYZ','Hungary','Europe',93030.00,10043200,'Magyarország'),(217,'XYZ','Uruguay','South America',175016.00,3337000,'Uruguay'),(218,'XYZ','New Caledonia','Oceania',18575.00,214000,'Nouvelle-Calédonie'),(219,'XYZ','New Zealand','Oceania',270534.00,3862000,'New Zealand/Aotearoa'),(220,'XYZ','Uzbekistan','Asia',447400.00,24318000,'Uzbekiston'),(221,'XYZ','Belarus','Europe',207600.00,10236000,'Belarus'),(222,'XYZ','Wallis and Futuna','Oceania',200.00,15000,'Wallis-et-Futuna'),(223,'XYZ','Vanuatu','Oceania',12189.00,190000,'Vanuatu'),(224,'XYZ','Holy See (Vatican City State)','Europe',0.40,1000,'Santa Sede/Città del Vaticano'),(225,'XYZ','Venezuela','South America',912050.00,24170000,'Venezuela'),(226,'XYZ','Russian Federation','Europe',17075400.00,146934000,'Rossija'),(227,'XYZ','Vietnam','Asia',331689.00,79832000,'Viêt Nam'),(228,'XYZ','Estonia','Europe',45227.00,1439200,'Eesti'),(229,'XYZ','United States','North America',9363520.00,278357000,'United States'),(230,'XYZ','Virgin Islands, U.S.','North America',347.00,93000,'Virgin Islands of the United States'),(231,'XYZ','Zimbabwe','Africa',390757.00,11669000,'Zimbabwe'),(232,'XYZ','Palestine','Asia',6257.00,3101000,'Filastin'),(233,'XYZ','Antarctica','Antarctica',13120000.00,0,'–'),(234,'XYZ','Bouvet Island','Antarctica',59.00,0,'Bouvetøya'),(235,'XYZ','British Indian Ocean Territory','Africa',78.00,0,'British Indian Ocean Territory'),(236,'XYZ','South Georgia and the South Sandwich Islands','Antarctica',3903.00,0,'South Georgia and the South Sandwich Islands'),(237,'XYZ','Heard Island and McDonald Islands','Antarctica',359.00,0,'Heard and McDonald Islands'),(238,'XYZ','French Southern territories','Antarctica',7780.00,0,'Terres australes françaises'),(240,'XYZ','','Asia',0.00,0,''),(241,'XYZ','','Asia',0.00,0,''),(242,'XYZ','','Asia',0.00,0,''),(243,'XYZ','','Asia',0.00,0,''),(244,'XYZ','','Asia',0.00,0,''),(245,'XYZ','','Asia',0.00,0,''),(246,'XYZ','','Asia',0.00,0,''),(247,'XYZ','','Asia',0.00,0,''),(252,'XYZ','','Asia',0.00,0,''),(253,'XYZ','','Asia',0.00,0,''),(254,'XYZ','','',0.00,0,''),(1000,'XYZ','XYZ','Asia',100.00,250,'Terres'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;