Advertisement
Guest User

Untitled

a guest
May 1st, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.35 KB | None | 0 0
  1. INSERT INTO states VALUES('California');
  2.  
  3. INSERT INTO person VALUES('0010', 'Butler', 'Francis',
  4.     '1945-08-16', 'Fountain Valley', '92708', 'California');        /*Contact*/
  5.  
  6. INSERT INTO person VALUES('0110', 'Butler', 'Adam',
  7.     '1965-05-16', 'Fountain Valley', '92708', 'California');        /*Physician*/
  8.  
  9. INSERT INTO person VALUES('0210', 'Cutler', 'Francis',
  10.     '1985-02-08', 'Fountain Valley', '92708', 'California');        /*Outpatient*/
  11.  
  12. INSERT INTO person VALUES('0310', 'Fower', 'Cauli',
  13.     '1993-08-28', 'Fountain Valley', '92708', 'California');        /*Resident*/
  14.  
  15. INSERT INTO person VALUES('0410', 'Pettel', 'Caurte',
  16.     '1976-04-13', 'Fountain Valley', '92708', 'California');        /*Volunteer*/
  17.    
  18. INSERT INTO person VALUES('0510', 'Barde', 'Keye',
  19.     '1996-09-13', 'Fountain Valley', '92708', 'California');        /*Nurse*/
  20.    
  21. INSERT INTO person VALUES('0610', 'Care', 'Randy',
  22.     '1999-01-29', 'Fountain Valley', '92708', 'California');        /*Staff*/
  23.    
  24. INSERT INTO person VALUES('0710', 'Caise', 'Gaeme',
  25.     '2002-09-07', 'Fountain Valley', '92708', 'California');        /*Technician*/
  26.    
  27. INSERT INTO person VALUES('0810', 'Sanchez', 'Jose',
  28.     '1996-05-13', 'Fountain Valley', '92708', 'California');
  29.    
  30. INSERT INTO person VALUES('0910', 'Reed', 'Hert',
  31.     '1996-06-21', 'Fountain Valley', '92708', 'California');        /*RN*/
  32.    
  33. ----------------------------------------------------------------------
  34.    
  35. INSERT INTO person VALUES('9010', 'Glode', 'Diego',
  36.     '1985-11-10', 'Long Beach', '90804', 'California');     /*Nurse*/
  37.  
  38. INSERT INTO person VALUES('8110', 'Hart', 'Adam',
  39.     '1975-11-11', 'Long Beach', '90804', 'California');     /*Nurse*/
  40.  
  41. INSERT INTO person VALUES('7210', 'Remos', 'Melissa',
  42.     '1999-07-15', 'Long Beach', '90804', 'California');     /*Nurse*/
  43.  
  44. INSERT INTO person VALUES('6310', 'Rede', 'Blake',
  45.     '1991-04-12', 'Long Beach', '90804', 'California');     /*Nurse*/
  46.  
  47. INSERT INTO person VALUES('5410', 'Thorne', 'Rosa',
  48.     '1998-04-07', 'Long Beach', '90804', 'California');     /*Volunteer*/
  49.    
  50. INSERT INTO person VALUES('4510', 'Fior', 'Risa',
  51.     '1990-09-24', 'Long Beach', '90804', 'California');
  52.    
  53. INSERT INTO person VALUES('3610', 'Gatte', 'Charlotte',
  54.     '1999-01-22', 'Long Beach', '90804', 'California');     /*Nurse*/
  55.    
  56. INSERT INTO person VALUES('2710', 'Cruise', 'Penelope',
  57.     '2001-06-27', 'Long Beach', '90840', 'California');     /*Technician*/
  58.    
  59. INSERT INTO person VALUES('1810', 'Dunn', 'Adam',
  60.     '1995-12-03', 'Long Beach', '90840', 'California');
  61.    
  62. INSERT INTO person VALUES('0911', 'Green', 'Ashley',
  63.     '1996-02-11', 'Long Beach', '90840', 'California');     /*Nurse*/
  64.    
  65. ----------------------------------------------------------------------
  66.    
  67. INSERT INTO person VALUES('9011', 'Barre', 'Patricia',
  68.     '1999-10-17', 'Whittier', '90602', 'California');
  69.  
  70. INSERT INTO person VALUES('8112', 'Carte', 'Nancy',
  71.     '1986-03-16', 'Whittier', '90602', 'California');   /*Staff*/
  72.  
  73. INSERT INTO person VALUES('7213', 'Juste', 'Vanessa',
  74.     '1979-11-09', 'Whittier', '90602', 'California');       /*Physician*/
  75.  
  76. INSERT INTO person VALUES('6314', 'Flor', 'Susana',
  77.     '1998-04-01', 'Whittier', '90602', 'California');
  78.  
  79. INSERT INTO person VALUES('5415', 'Garcia', 'Flor',
  80.     '1991-06-24', 'Whittier', '90602', 'California');   /*Staff*/
  81.    
  82. INSERT INTO person VALUES('4516', 'Hurte', 'Harold',
  83.     '1999-06-16', 'Whittier', '90602', 'California');       /*Volunteer*/
  84.    
  85. INSERT INTO person VALUES('3617', 'Diaz', 'Charlotte',
  86.     '1994-05-02', 'Whittier', '90602', 'California');   /*Physician*/
  87.    
  88. INSERT INTO person VALUES('2718', 'Gomez', 'Laura',
  89.     '2002-08-25', 'Whittier', '90602', 'California');   /*Outpatient*/
  90.    
  91. INSERT INTO person VALUES('1819', 'Giar', 'Janet',
  92.     '1993-11-13', 'Whittier', '90602', 'California');   /*RN*/
  93.    
  94. INSERT INTO person VALUES('0920', 'Knok', 'Cheyenne',
  95.     '1999-11-22', 'Whittier', '90602', 'California');   /*Physician*/
  96.    
  97. ----------------------------------------------------------------------
  98.    
  99. INSERT INTO person VALUES('1011', 'Holmes', 'Jessica',
  100.     '1991-10-21', 'Lakewood', '90712', 'California');
  101.  
  102. INSERT INTO person VALUES('1112', 'Barde', 'Adriana',
  103.     '1996-04-24', 'Lakewood', '90712', 'California');   /*Technician*/
  104.  
  105. INSERT INTO person VALUES('1213', 'Garde', 'Jeanette',
  106.     '1983-12-14', 'Lakewood', '90712', 'California');
  107.  
  108. INSERT INTO person VALUES('1314', 'Carte', 'Melisa',
  109.     '1999-08-30', 'Lakewood', '90712', 'California');   /*Nurse*/
  110.  
  111. INSERT INTO person VALUES('1415', 'Garcia', 'Susana',
  112.     '1991-06-24', 'Lakewood', '90712', 'California');       /*Volunteer*/
  113.    
  114. INSERT INTO person VALUES('1516', 'Castello', 'Gerald',
  115.     '1993-07-11', 'Lakewood', '90712', 'California');   /*Staff*/
  116.    
  117. INSERT INTO person VALUES('1617', 'Rose', 'Marie',
  118.     '1995-06-14', 'Lakewood', '90712', 'California');   /*Staff*/
  119.    
  120. INSERT INTO person VALUES('1718', 'Booke', 'Helena',
  121.     '2005-04-21', 'Lakewood', '90712', 'California');       /*Outpatient*/
  122.    
  123. INSERT INTO person VALUES('1812', 'Cutler', 'Emily',
  124.     '1983-03-23', 'Lakewood', '90712', 'California');   /*RN*/
  125.    
  126. INSERT INTO person VALUES('1920', 'Cooke', 'Gerald',
  127.     '1998-12-12', 'Lakewood', '90712', 'California');
  128.    
  129. ----------------------------------------------------------------------
  130.    
  131. INSERT INTO person VALUES('1111', 'Holmes', 'Catherine',
  132.     '1996-02-20', 'Westminster', '92683', 'California');    /*Outpatient*/
  133.  
  134. INSERT INTO person VALUES('1122', 'Garcia', 'Katherine',
  135.     '1985-07-14', 'Westminster', '92683', 'California');    /*Resident*/
  136.  
  137. INSERT INTO person VALUES('1211', 'Hart', 'Jeanette',
  138.     '1989-10-10', 'Westminster', '92683', 'California');    /*Resident*/
  139.  
  140. INSERT INTO person VALUES('1311', 'Cortez', 'Jennifer',
  141.     '1991-07-15', 'Westminster', '92683', 'California');
  142.  
  143. INSERT INTO person VALUES('1411', 'Forke', 'Paulina',
  144.     '1964-09-27', 'Westminster', '92683', 'California');    /*Resident*/
  145.    
  146. INSERT INTO person VALUES('1511', 'Forke', 'Paul',
  147.     '1976-09-19', 'Westminster', '92683', 'California');    /*Physician*/
  148.    
  149. INSERT INTO person VALUES('1611', 'Sahl', 'Sean',
  150.     '1989-12-19', 'Westminster', '92683', 'California');    /*RN*/
  151.    
  152. INSERT INTO person VALUES('1711', 'Penn', 'Jack',
  153.     '2000-08-29', 'Westminster', '92683', 'California');    /*Volunteer*/
  154.    
  155. INSERT INTO person VALUES('1811', 'Vasquez', 'Mark',
  156.     '1986-05-12', 'Westminster', '92683', 'California');
  157.    
  158. INSERT INTO person VALUES('1921', 'Sterling', 'Ethan',
  159.     '1996-10-18', 'Westminster', '92683', 'California');    /*Outpatient*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement