qpZnWXHt

1USE world;
2
3DROP TABLE IF EXISTS gallerys;
4
5CREATE TABLE gallerys(
6GalleryID	 INT Primary Key auto_increment,
7CityName 	 VarChar(43) Not Null,
8CountryName  VarChar(43) Not Null,
9SightName    VarChar(43) Not Null,
10Amenity		 VarChar(3)
11); 
12 
13INSERT INTO gallerys (CityName,CountryName,SightName,Amenity) Values 
14	("Kabur","Afghanistan","Gallery1","Yes"),
15    ("Qandahar","Afghanistan","Gallery2",NULL),
16    ("La Plata","Afghanistan","Gallery3","Yes"),
17    ("Mazar-e-Sharif","Afghanistan","Gallery4",NULL),
18    ("Amsterdams","Netherlands","Gallery5","Yes"),
19    ("Rotterdam","Netherlands","Gallery6","Yes"),
20    ("Haags","Netherlands","Gallery7","Yes"),
21    ("Willemstad","Netherlands Antilles","Gallery8",NULL),
22    ("Tirana","Albania","Sight9",NULL),
23    ("San Miguel","Argentina","Gallery10","Yes"),
24    ("Groningen","Netherlands","Gallery11",NULL),
25    ("Las Heras","Argentina","Gallery12","Yes"),
26    ("Apeldoorn","Netherlands","Sight13",NULL),
27    ("Nijmegen","Netherlands","Sight14","Yes"),
28    ("Enschede","Netherlands","Sight15",NULL),
29    ("Haarlem","Netherlands","Sight16","Yes"),
30    ("Almere","Netherlands","Sight17",NULL),
31    ("Gent","Belgium","Sight18","Yes"),
32    ("Amersfoort","Netherlands","Sight19",NULL),
33    ("Leiden","Netherlands","Sight20","Yes");