Hydrinx

SQL Assignment Data Input

Jul 3rd, 2020
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.95 KB | None | 0 0
  1. INSERT INTO account_logins
  2. VALUES ('1', 'Nick', 'password123', 'nickster@gmail.com', 'health requirements', 'x2 Adult');
  3.  
  4. INSERT INTO account_logins
  5. VALUES ('2', 'Jenifer', 'omgitsjen12', 'jennysflowers@gmail.com', 'enjoys cooking', 'x2 promotion, x3 child');
  6.  
  7. INSERT INTO cinemas
  8. VALUES ('1', 'cineworld', '3', '24');
  9.  
  10. INSERT INTO cinemas
  11. VALUES ('2', 'odeon', '2', '36');
  12.  
  13. INSERT INTO cinemas
  14. VALUES ('3', 'vue', '4', '40');
  15.  
  16. INSERT INTO movies
  17. VALUES ('1', 'Joker', 'Feburary', '2020', '17.00', '2', 'Action', '15');
  18.  
  19. INSERT INTO movies
  20. VALUES ('2', 'Harry Potter', 'Feburary', '2020', '17.00', '2','Fantasy', '18');
  21.  
  22. INSERT INTO movies
  23. VALUES ('3', 'The Shining', 'March', '2020', '17.30','3','Horror', '18');
  24.  
  25. INSERT INTO movies
  26. VALUES ('4', 'Chicken Little', 'March', '2019', '18.00','2','Adventure', '18');
  27.  
  28. INSERT INTO movies
  29. VALUES ('5', 'Sonic', 'April', '2020', 'Comedy', '18.00','1', '18');
  30.  
  31. INSERT INTO seat_price
  32. VALUES ('1', '2', '1', '0', '0', '0', '2', '0', '10','12','7','8','12','5', '0');
  33.  
  34. INSERT INTO seat_price
  35. VALUES ('2', '0', '0', '1', '1', '1', '2', '2', '11','14','3','6','17','5', '0');
  36.  
  37. INSERT INTO seat_price
  38. VALUES ('3', '0', '0', '0', '1', '1', '0', '0', '19','12','5','5','19','5', '0');
  39.  
  40. INSERT INTO movie_seat_booking
  41. VALUES ('1', '1', 'G', '7', '1','3');
  42.  
  43. INSERT INTO movie_seat_booking
  44. VALUES ('2', '1', 'G', '8', '1', '3');
  45.  
  46. INSERT INTO movie_seat_booking
  47. VALUES ('3', '1', 'G', '9', '1', '3');
  48.  
  49. INSERT INTO movie_seat_booking
  50. VALUES ('4', '2', 'C', '1', '4', '2');
  51.  
  52. INSERT INTO movie_seat_booking
  53. VALUES ('5', '2', 'D', '2', '4', '2');
  54.  
  55. INSERT INTO movie_seat_booking
  56. VALUES ('6', '2', 'R', '2', '4', '2');
  57.  
  58. INSERT INTO movie_seat_booking
  59. VALUES ('7', '2', 'G', '2', '4', '2');
  60.  
  61. INSERT INTO movie_seat_booking
  62. VALUES ('8', '2', 'F', '2', '4', '2');
  63.  
  64. INSERT INTO movie_seat_booking
  65. VALUES ('9', '2', 'E', '2', '4', '2');
  66.  
  67. INSERT INTO movie_seat_booking
  68. VALUES ('10','2', 'B', '2', '4', '2');
Add Comment
Please, Sign In to add comment