-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathCreate_Insert.sql
More file actions
112 lines (108 loc) · 7.77 KB
/
Create_Insert.sql
File metadata and controls
112 lines (108 loc) · 7.77 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
CREATE SCHEMA jaskaran_schema;
CREATE TABLE jaskaran_schema.Persons (
PersonID int,
FullName varchar(255),
City varchar(255),
PRIMARY KEY (PersonID)
);
INSERT INTO jaskaran_schema.Persons VALUES (0,'Herman Zimmerman','Oklahoma City');
INSERT INTO jaskaran_schema.Persons VALUES (1,'Lisa Ray','Columbus');
INSERT INTO jaskaran_schema.Persons VALUES (2,'Terrell Reeves','Jacksonville');
INSERT INTO jaskaran_schema.Persons VALUES (3,'Steve Goodwin','Charlotte');
INSERT INTO jaskaran_schema.Persons VALUES (4,'Leah Tran','Detroit');
INSERT INTO jaskaran_schema.Persons VALUES (5,'Wilbert Holmes','Washington');
INSERT INTO jaskaran_schema.Persons VALUES (6,'Mindy George','Los Angeles');
INSERT INTO jaskaran_schema.Persons VALUES (7,'Rosa Huff','Phoenix');
INSERT INTO jaskaran_schema.Persons VALUES (8,'Clayton Jennings','Denver');
INSERT INTO jaskaran_schema.Persons VALUES (9,'Darla Hayes','Charlotte');
INSERT INTO jaskaran_schema.Persons VALUES (10,'Jack Hicks','Houston');
INSERT INTO jaskaran_schema.Persons VALUES (11,'Francis Davidson','Austin');
INSERT INTO jaskaran_schema.Persons VALUES (12,'Jerome Padilla','San Francisco');
INSERT INTO jaskaran_schema.Persons VALUES (13,'Mamie Duncan','Houston');
INSERT INTO jaskaran_schema.Persons VALUES (14,'Julia Cain','San Jose');
INSERT INTO jaskaran_schema.Persons VALUES (15,'Leslie Klein','Seattle');
INSERT INTO jaskaran_schema.Persons VALUES (16,'Isaac Bridges','Philadelphia');
INSERT INTO jaskaran_schema.Persons VALUES (17,'Martin Adkins','Chicago');
INSERT INTO jaskaran_schema.Persons VALUES (18,'Vincent Perry','Detroit');
INSERT INTO jaskaran_schema.Persons VALUES (19,'William Porter','Fort Worth');
INSERT INTO jaskaran_schema.Persons VALUES (20,'Domingo Byrd','Charlotte');
INSERT INTO jaskaran_schema.Persons VALUES (21,'Leslie Torres','San Francisco');
INSERT INTO jaskaran_schema.Persons VALUES (22,'Wanda Morrison','El Paso');
INSERT INTO jaskaran_schema.Persons VALUES (23,'Gwen Caldwell','Indianapolis');
INSERT INTO jaskaran_schema.Persons VALUES (24,'Tammy Daniels','Indianapolis');
INSERT INTO jaskaran_schema.Persons VALUES (25,'Claude Gilbert','Phoenix');
INSERT INTO jaskaran_schema.Persons VALUES (26,'Monique Bowers','Seattle');
INSERT INTO jaskaran_schema.Persons VALUES (27,'Virginia Phillips','San Francisco');
INSERT INTO jaskaran_schema.Persons VALUES (28,'Norman Graham','Columbus');
INSERT INTO jaskaran_schema.Persons VALUES (29,'Gerard Fleming','San Jose');
INSERT INTO jaskaran_schema.Persons VALUES (30,'Miranda Conner','Washington');
INSERT INTO jaskaran_schema.Persons VALUES (31,'Alicia Mcdaniel','Indianapolis');
INSERT INTO jaskaran_schema.Persons VALUES (32,'Miriam Erickson','Dallas');
INSERT INTO jaskaran_schema.Persons VALUES (33,'Tyrone Hughes','Houston');
INSERT INTO jaskaran_schema.Persons VALUES (34,'Peter Terry','Phoenix');
INSERT INTO jaskaran_schema.Persons VALUES (35,'Julie Boone','Jacksonville');
INSERT INTO jaskaran_schema.Persons VALUES (36,'Josephine Sherman','Boston');
INSERT INTO jaskaran_schema.Persons VALUES (37,'Bridget Stevenson','Dallas');
INSERT INTO jaskaran_schema.Persons VALUES (38,'Dave Thomas','San Antonio');
INSERT INTO jaskaran_schema.Persons VALUES (39,'Francisco Holland','Indianapolis');
INSERT INTO jaskaran_schema.Persons VALUES (40,'Garrett Hogan','Phoenix');
INSERT INTO jaskaran_schema.Persons VALUES (41,'Verna Abbott','El Paso');
INSERT INTO jaskaran_schema.Persons VALUES (42,'Mona Rios','Portland');
INSERT INTO jaskaran_schema.Persons VALUES (43,'Tara Glover','Dallas');
INSERT INTO jaskaran_schema.Persons VALUES (44,'Levi Arnold','Denver');
INSERT INTO jaskaran_schema.Persons VALUES (45,'Jasmine Gutierrez','San Jose');
INSERT INTO jaskaran_schema.Persons VALUES (46,'Abraham Ortega','San Francisco');
INSERT INTO jaskaran_schema.Persons VALUES (47,'Heidi Ellis','Columbus');
INSERT INTO jaskaran_schema.Persons VALUES (48,'Nathaniel Morales','Washington');
INSERT INTO jaskaran_schema.Persons VALUES (49,'Stephen Harvey','Phoenix');
INSERT INTO jaskaran_schema.Persons VALUES (50,'Kimberly Jordan','El Paso');
INSERT INTO jaskaran_schema.Persons VALUES (51,'Jessie Carson','Nashville-Davidson');
INSERT INTO jaskaran_schema.Persons VALUES (52,'Juan West','Phoenix');
INSERT INTO jaskaran_schema.Persons VALUES (53,'Ernestine Cummings','Columbus');
INSERT INTO jaskaran_schema.Persons VALUES (54,'Oscar Wolfe','San Antonio');
INSERT INTO jaskaran_schema.Persons VALUES (55,'Evan Smith','San Antonio');
INSERT INTO jaskaran_schema.Persons VALUES (56,'Regina Garrett','Seattle');
INSERT INTO jaskaran_schema.Persons VALUES (57,'Daisy Dixon','Detroit');
INSERT INTO jaskaran_schema.Persons VALUES (58,'Warren Cross','Jacksonville');
INSERT INTO jaskaran_schema.Persons VALUES (59,'Inez Mcgee','San Francisco');
INSERT INTO jaskaran_schema.Persons VALUES (60,'Ellis Pena','Philadelphia');
INSERT INTO jaskaran_schema.Persons VALUES (61,'Lois Parker','Fort Worth');
INSERT INTO jaskaran_schema.Persons VALUES (62,'Charlene King','Portland');
INSERT INTO jaskaran_schema.Persons VALUES (63,'Olga Luna','Oklahoma City');
INSERT INTO jaskaran_schema.Persons VALUES (64,'Maria Jenkins','Nashville-Davidson');
INSERT INTO jaskaran_schema.Persons VALUES (65,'Phyllis Scott','Washington');
INSERT INTO jaskaran_schema.Persons VALUES (66,'Sean Palmer','Detroit');
INSERT INTO jaskaran_schema.Persons VALUES (67,'Carroll Weber','Oklahoma City');
INSERT INTO jaskaran_schema.Persons VALUES (68,'Dorothy Hudson','Nashville-Davidson');
INSERT INTO jaskaran_schema.Persons VALUES (69,'Maurice Chandler','Boston');
INSERT INTO jaskaran_schema.Persons VALUES (70,'Lloyd Cruz','Seattle');
INSERT INTO jaskaran_schema.Persons VALUES (71,'Christian Stanley','San Francisco');
INSERT INTO jaskaran_schema.Persons VALUES (72,'Emma Carter','San Diego');
INSERT INTO jaskaran_schema.Persons VALUES (73,'Oliver Figueroa','Austin');
INSERT INTO jaskaran_schema.Persons VALUES (74,'Bessie Kelly','Philadelphia');
INSERT INTO jaskaran_schema.Persons VALUES (75,'Malcolm Nelson','Boston');
INSERT INTO jaskaran_schema.Persons VALUES (76,'Rick Gibson','Houston');
INSERT INTO jaskaran_schema.Persons VALUES (77,'Geraldine Mendez','Jacksonville');
INSERT INTO jaskaran_schema.Persons VALUES (78,'Sharon Weaver','Denver');
INSERT INTO jaskaran_schema.Persons VALUES (79,'Jerry Cox','Indianapolis');
INSERT INTO jaskaran_schema.Persons VALUES (80,'Ray Bowman','Philadelphia');
INSERT INTO jaskaran_schema.Persons VALUES (81,'Samantha Myers','Austin');
INSERT INTO jaskaran_schema.Persons VALUES (82,'Jesus Pierce','Oklahoma City');
INSERT INTO jaskaran_schema.Persons VALUES (83,'Pearl Jacobs','Phoenix');
INSERT INTO jaskaran_schema.Persons VALUES (84,'Clara Barnett','Los Angeles');
INSERT INTO jaskaran_schema.Persons VALUES (85,'Ronald Shaw','Columbus');
INSERT INTO jaskaran_schema.Persons VALUES (86,'Christine Quinn','Jacksonville');
INSERT INTO jaskaran_schema.Persons VALUES (87,'Alton Elliott','Philadelphia');
INSERT INTO jaskaran_schema.Persons VALUES (88,'Krystal Moreno','San Jose');
INSERT INTO jaskaran_schema.Persons VALUES (89,'Rhonda Owens','Seattle');
INSERT INTO jaskaran_schema.Persons VALUES (90,'Katie Robbins','Phoenix');
INSERT INTO jaskaran_schema.Persons VALUES (91,'Jeremy Chapman','Portland');
INSERT INTO jaskaran_schema.Persons VALUES (92,'Douglas Young','New York');
INSERT INTO jaskaran_schema.Persons VALUES (93,'Kate Mcbride','Chicago');
INSERT INTO jaskaran_schema.Persons VALUES (94,'Jackie Mckenzie','Washington');
INSERT INTO jaskaran_schema.Persons VALUES (95,'Debbie Keller','Jacksonville');
INSERT INTO jaskaran_schema.Persons VALUES (96,'Pam Casey','Las Vegas');
INSERT INTO jaskaran_schema.Persons VALUES (97,'Emily Coleman','Portland');
INSERT INTO jaskaran_schema.Persons VALUES (98,'Terence Ross','Detroit');
INSERT INTO jaskaran_schema.Persons VALUES (99,'Lorene Peterson','San Francisco');
INSERT INTO jaskaran_schema.Persons VALUES (100,'Jaskaran Singh','Toronto');