UXCDWH1Y

1USE world;
2
3DROP TABLE IF EXISTS gallerys;
4
5CREATE TABLE gallerys(
6GalleryID	 			 INT Primary Key auto_increment,
7CityID	 			 VarChar(43) Not Null,
8GalleryName    			 VarChar(43) Not Null,
9FeaturesAndArtists		 VarChar(3)
10--FOREIGN KEY (CityID)
11--REFERENCES city (CityID)
12); 
13
14 
15INSERT INTO gallerys (CityID,GalleryName,FeaturesAndArtists) Values 
16	(484,"Gallery1","Yes"),
17    (498,"Gallery2",NULL),
18    (484,"Gallery3","Yes"),
19    (716,"Gallery4",NULL),
20    (265,"Gallery5","Yes"),
21    (610,"Gallery6","Yes"),
22    (406,"Gallery7","Yes"),
23    (665,"Gallery8",NULL),
24    (704,"Gallery9",NULL),
25    (923,"Gallery10","Yes"),
26    (922,"Gallery11",NULL),
27    (145,"Gallery12","Yes"),
28    (3,"Gallery13",NULL),
29    (57,"Gallery14","Yes"),
30    (889,"Gallery15",NULL),
31    (894,"Gallery16","Yes"),
32    (602,"Gallery17",NULL),
33    (105,"Gallery18","Yes"),
34    (1,"Gallery19",NULL),
35    (61,"Gallery20","Yes");