#--------------------------------------------------------------------
# One line comment for MySQL start with a # rather than // as in Java
#--------------------------------------------------------------------

# Insert table records one-at-a-time.  Each insert ends with a semi-colon

insert into abductee(fname, lname, numTrips) values('Mickey','Rooney',  37);

insert into abductee(lname, fname, numTrips) values('Fields','Sally',  8);

insert into abductee(lname, numTrips) values('Dale', 303);




# Insert table records many at once -- semi-colon at end.  

insert into abductee(lname, fname, numTrips)
  values 
         (         'Boyd' ,        'Nicole' ,   3 )
        ,(        'Cheek' ,     'Valentino' ,   1 )
        ,(      'DiNella' ,       'Vincent' , 101 )
        ,(   'Eldmerdash' ,       'Mustafa' ,  43 )
        ,(       'Garcia' ,       'Gabriel' ,   2 )
        ,(        'Haque' ,        'Ashraf' ,   1 )
        ,(       'Harvey' ,         'Julia' ,  41 )
        ,(         'Khan' ,        'Sherry' ,   2 )
        ,(     'Kilbride' ,          'Lane' ,   3 )
        ,(      'Komnick' ,       'Michael' ,   0 )
        ,(           'Le' ,         'Hoang' ,   3 )
        ,(          'Lim' ,        'Debbie' ,   0 )
        ,(      'Makazhu' ,           'Bob' ,   1 )
        ,(       'McCall' ,          'Jack' ,  58 )
  ;





# Insert table records many at once -- semi-colon at end.  

insert into abductee(lname, fname, hometown, numTrips)
 values
         (         'Ngan' ,        'Nguyen' ,  'NotSewanee' ,    3 )
        ,(       'Hallie' ,        'Rutten' ,  'NotSewanee' ,   40 )
        ,(        'Jadon' ,         'Silva' ,  'NotSewanee' ,    2 )
        ,(         'Nick' ,          'Song' ,  'NotSewanee' ,   18 )
        ,(     'Mitchell' ,   'vom Scheidt' ,  'NotSewanee' ,    1 )
  ;