API tools faq
paste
Advertisement
wa12rior

Zad5 Bazy Bar

wa12rior
Nov 26th, 2019
166
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 25.36 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE z5_faktury(nr_zamowienia int NOT NULL AUTO_INCREMENT PRIMARY KEY, imie varchar(50), nazwisko varchar(100), towar varchar(50), cena int, sztuki int, data_zamowienia varchar(100));
  2.  
  3. INSERT INTO z5_faktury VALUES(1,'Marcin','Markiewicz','Towar C',30,8,'2019-11-26');
  4. INSERT INTO z5_faktury VALUES(2,'Aneta','Anekiewicz','Towar B',20,10,'2019-11-25');
  5. INSERT INTO z5_faktury VALUES(3,'Józef','Józkiewicz','Towar B',20,2,'2019-11-24');
  6. INSERT INTO z5_faktury VALUES(4,'Antonina','Antkiewicz','Towar C',30,8,'2019-11-23');
  7. INSERT INTO z5_faktury VALUES(5,'Dorota','Dorkiewicz','Towar B',20,2,'2019-11-22');
  8. INSERT INTO z5_faktury VALUES(6,'Piotr','Piokiewicz','Towar B',20,5,'2019-11-21');
  9. INSERT INTO z5_faktury VALUES(7,'Dominika','Domkiewicz','Towar C',30,7,'2019-11-20');
  10. INSERT INTO z5_faktury VALUES(8,'Ariana','Arikiewicz','Towar B',20,4,'2019-11-19');
  11. INSERT INTO z5_faktury VALUES(9,'Marzena','Markiewicz','Towar B',20,1,'2019-11-18');
  12. INSERT INTO z5_faktury VALUES(10,'Zbigniew','Zbikiewicz','Towar A',10,4,'2019-11-17');
  13. INSERT INTO z5_faktury VALUES(11,'Joanna','Joakiewicz','Towar B',20,6,'2019-11-16');
  14. INSERT INTO z5_faktury VALUES(12,'Sławomir','Słakiewicz','Towar C',30,8,'2019-11-15');
  15. INSERT INTO z5_faktury VALUES(13,'Marcin','Markiewicz','Towar B',20,5,'2019-11-14');
  16. INSERT INTO z5_faktury VALUES(14,'Szymon','Szykiewicz','Towar B',20,11,'2019-11-13');
  17. INSERT INTO z5_faktury VALUES(15,'Wincenty','Winkiewicz','Towar A',10,8,'2019-11-12');
  18. INSERT INTO z5_faktury VALUES(16,'Kamila','Kamkiewicz','Towar B',20,7,'2019-11-11');
  19. INSERT INTO z5_faktury VALUES(17,'Natan','Natkiewicz','Towar B',20,10,'2019-11-10');
  20. INSERT INTO z5_faktury VALUES(18,'Maria','Markiewicz','Towar A',10,3,'2019-11-09');
  21. INSERT INTO z5_faktury VALUES(19,'Izabela','Izakiewicz','Towar B',20,9,'2019-11-08');
  22. INSERT INTO z5_faktury VALUES(20,'Julian','Julkiewicz','Towar A',10,5,'2019-11-07');
  23. INSERT INTO z5_faktury VALUES(21,'Marcin','Markiewicz','Towar B',20,3,'2019-11-06');
  24. INSERT INTO z5_faktury VALUES(22,'Joanna','Joakiewicz','Towar A',10,8,'2019-11-05');
  25. INSERT INTO z5_faktury VALUES(23,'Bernadetta','Berkiewicz','Towar C',30,4,'2019-11-04');
  26. INSERT INTO z5_faktury VALUES(24,'Izabela','Izakiewicz','Towar A',10,8,'2019-11-03');
  27. INSERT INTO z5_faktury VALUES(25,'Kamila','Kamkiewicz','Towar B',20,11,'2019-11-02');
  28. INSERT INTO z5_faktury VALUES(26,'Magdalena','Magkiewicz','Towar A',10,3,'2019-11-01');
  29. INSERT INTO z5_faktury VALUES(27,'Jagna','Jagkiewicz','Towar B',20,6,'2019-10-31');
  30. INSERT INTO z5_faktury VALUES(28,'Bożena','Bożkiewicz','Towar B',20,11,'2019-10-30');
  31. INSERT INTO z5_faktury VALUES(29,'Antonina','Antkiewicz','Towar A',10,3,'2019-10-29');
  32. INSERT INTO z5_faktury VALUES(30,'Wojciech','Wojkiewicz','Towar C',30,6,'2019-10-28');
  33. INSERT INTO z5_faktury VALUES(31,'Jozue','Jozkiewicz','Towar C',30,10,'2019-10-27');
  34. INSERT INTO z5_faktury VALUES(32,'Julia','Julkiewicz','Towar B',20,10,'2019-10-26');
  35. INSERT INTO z5_faktury VALUES(33,'Jozue','Jozkiewicz','Towar B',20,10,'2019-10-25');
  36. INSERT INTO z5_faktury VALUES(34,'Leon','Leokiewicz','Towar B',20,4,'2019-10-24');
  37. INSERT INTO z5_faktury VALUES(35,'Julia','Julkiewicz','Towar A',10,8,'2019-10-23');
  38. INSERT INTO z5_faktury VALUES(36,'Nikola','Nikkiewicz','Towar C',30,4,'2019-10-22');
  39. INSERT INTO z5_faktury VALUES(37,'Lucyna','Luckiewicz','Towar C',30,3,'2019-10-21');
  40. INSERT INTO z5_faktury VALUES(38,'Jan','Jankiewicz','Towar A',10,3,'2019-10-20');
  41. INSERT INTO z5_faktury VALUES(39,'Zuzanna','Zuzkiewicz','Towar A',10,4,'2019-10-19');
  42. INSERT INTO z5_faktury VALUES(40,'Aleksander','Alekiewicz','Towar B',20,7,'2019-10-18');
  43. INSERT INTO z5_faktury VALUES(41,'Leon','Leokiewicz','Towar A',10,11,'2019-10-17');
  44. INSERT INTO z5_faktury VALUES(42,'Krzysztof','Krzkiewicz','Towar B',20,10,'2019-10-16');
  45. INSERT INTO z5_faktury VALUES(43,'Jozue','Jozkiewicz','Towar B',20,4,'2019-10-15');
  46. INSERT INTO z5_faktury VALUES(44,'Jadwiga','Jadkiewicz','Towar B',20,4,'2019-10-14');
  47. INSERT INTO z5_faktury VALUES(45,'Franciszek','Frakiewicz','Towar A',10,9,'2019-10-13');
  48. INSERT INTO z5_faktury VALUES(46,'Sławomir','Słakiewicz','Towar B',20,9,'2019-10-12');
  49. INSERT INTO z5_faktury VALUES(47,'Hanna','Hankiewicz','Towar A',10,7,'2019-10-11');
  50. INSERT INTO z5_faktury VALUES(48,'Pamela','Pamkiewicz','Towar B',20,6,'2019-10-10');
  51. INSERT INTO z5_faktury VALUES(49,'Wojciech','Wojkiewicz','Towar B',20,11,'2019-10-09');
  52. INSERT INTO z5_faktury VALUES(50,'Leon','Leokiewicz','Towar C',30,6,'2019-10-08');
  53. INSERT INTO z5_faktury VALUES(51,'Krystyna','Krykiewicz','Towar B',20,3,'2019-10-07');
  54. INSERT INTO z5_faktury VALUES(52,'Krystyna','Krykiewicz','Towar A',10,5,'2019-10-06');
  55. INSERT INTO z5_faktury VALUES(53,'Józef','Józkiewicz','Towar B',20,4,'2019-10-05');
  56. INSERT INTO z5_faktury VALUES(54,'Marzena','Markiewicz','Towar B',20,8,'2019-10-04');
  57. INSERT INTO z5_faktury VALUES(55,'Piotr','Piokiewicz','Towar B',20,5,'2019-10-03');
  58. INSERT INTO z5_faktury VALUES(56,'Andrzej','Andkiewicz','Towar B',20,2,'2019-10-02');
  59. INSERT INTO z5_faktury VALUES(57,'Helena','Helkiewicz','Towar C',30,4,'2019-10-01');
  60. INSERT INTO z5_faktury VALUES(58,'Lilianna','Lilkiewicz','Towar B',20,10,'2019-09-30');
  61. INSERT INTO z5_faktury VALUES(59,'Zuzanna','Zuzkiewicz','Towar A',10,6,'2019-09-29');
  62. INSERT INTO z5_faktury VALUES(60,'Petronella','Petkiewicz','Towar C',30,9,'2019-09-28');
  63. INSERT INTO z5_faktury VALUES(61,'Sylwia','Sylkiewicz','Towar B',20,10,'2019-09-27');
  64. INSERT INTO z5_faktury VALUES(62,'Maksymilian','Makkiewicz','Towar B',20,1,'2019-09-26');
  65. INSERT INTO z5_faktury VALUES(63,'Bożena','Bożkiewicz','Towar B',20,5,'2019-09-25');
  66. INSERT INTO z5_faktury VALUES(64,'Joanna','Joakiewicz','Towar C',30,8,'2019-09-24');
  67. INSERT INTO z5_faktury VALUES(65,'Marzena','Markiewicz','Towar B',20,9,'2019-09-23');
  68. INSERT INTO z5_faktury VALUES(66,'Odetta','Odekiewicz','Towar B',20,2,'2019-09-22');
  69. INSERT INTO z5_faktury VALUES(67,'Sławomir','Słakiewicz','Towar B',20,9,'2019-09-21');
  70. INSERT INTO z5_faktury VALUES(68,'Aneta','Anekiewicz','Towar B',20,2,'2019-09-20');
  71. INSERT INTO z5_faktury VALUES(69,'Adrianna','Adrkiewicz','Towar B',20,10,'2019-09-19');
  72. INSERT INTO z5_faktury VALUES(70,'Bernadetta','Berkiewicz','Towar B',20,7,'2019-09-18');
  73. INSERT INTO z5_faktury VALUES(71,'Jagna','Jagkiewicz','Towar B',20,2,'2019-09-17');
  74. INSERT INTO z5_faktury VALUES(72,'Pamela','Pamkiewicz','Towar A',10,8,'2019-09-16');
  75. INSERT INTO z5_faktury VALUES(73,'Arkadiusz','Arkkiewicz','Towar C',30,9,'2019-09-15');
  76. INSERT INTO z5_faktury VALUES(74,'Mirella','Mirkiewicz','Towar B',20,5,'2019-09-14');
  77. INSERT INTO z5_faktury VALUES(75,'Jozue','Jozkiewicz','Towar B',20,1,'2019-09-13');
  78. INSERT INTO z5_faktury VALUES(76,'Lilianna','Lilkiewicz','Towar C',30,10,'2019-09-12');
  79. INSERT INTO z5_faktury VALUES(77,'Bogumiła','Bogkiewicz','Towar A',10,2,'2019-09-11');
  80. INSERT INTO z5_faktury VALUES(78,'Mirella','Mirkiewicz','Towar A',10,6,'2019-09-10');
  81. INSERT INTO z5_faktury VALUES(79,'Arkadiusz','Arkkiewicz','Towar C',30,9,'2019-09-09');
  82. INSERT INTO z5_faktury VALUES(80,'Lucyna','Luckiewicz','Towar B',20,10,'2019-09-08');
  83. INSERT INTO z5_faktury VALUES(81,'Stanisław','Stakiewicz','Towar A',10,2,'2019-09-07');
  84. INSERT INTO z5_faktury VALUES(82,'Lilianna','Lilkiewicz','Towar B',20,5,'2019-09-06');
  85. INSERT INTO z5_faktury VALUES(83,'Franciszek','Frakiewicz','Towar A',10,7,'2019-09-05');
  86. INSERT INTO z5_faktury VALUES(84,'Nikola','Nikkiewicz','Towar B',20,11,'2019-09-04');
  87. INSERT INTO z5_faktury VALUES(85,'Jadwiga','Jadkiewicz','Towar C',30,2,'2019-09-03');
  88. INSERT INTO z5_faktury VALUES(86,'Leon','Leokiewicz','Towar A',10,1,'2019-09-02');
  89. INSERT INTO z5_faktury VALUES(87,'Maria','Markiewicz','Towar A',10,1,'2019-09-01');
  90. INSERT INTO z5_faktury VALUES(88,'Antonina','Antkiewicz','Towar B',20,3,'2019-08-31');
  91. INSERT INTO z5_faktury VALUES(89,'Petronella','Petkiewicz','Towar C',30,1,'2019-08-30');
  92. INSERT INTO z5_faktury VALUES(90,'Wioleta','Wiokiewicz','Towar C',30,10,'2019-08-29');
  93. INSERT INTO z5_faktury VALUES(91,'Maksymilian','Makkiewicz','Towar B',20,7,'2019-08-28');
  94. INSERT INTO z5_faktury VALUES(92,'Bernadetta','Berkiewicz','Towar C',30,8,'2019-08-27');
  95. INSERT INTO z5_faktury VALUES(93,'Sławomir','Słakiewicz','Towar C',30,2,'2019-08-26');
  96. INSERT INTO z5_faktury VALUES(94,'Franciszek','Frakiewicz','Towar B',20,2,'2019-08-25');
  97. INSERT INTO z5_faktury VALUES(95,'Bożena','Bożkiewicz','Towar B',20,2,'2019-08-24');
  98. INSERT INTO z5_faktury VALUES(96,'Lilianna','Lilkiewicz','Towar B',20,9,'2019-08-23');
  99. INSERT INTO z5_faktury VALUES(97,'Nikola','Nikkiewicz','Towar A',10,8,'2019-08-22');
  100. INSERT INTO z5_faktury VALUES(98,'Wiliam','Wilkiewicz','Towar B',20,6,'2019-08-21');
  101. INSERT INTO z5_faktury VALUES(99,'Jacek','Jackiewicz','Towar C',30,5,'2019-08-20');
  102. INSERT INTO z5_faktury VALUES(100,'Martyna','Markiewicz','Towar C',30,6,'2019-08-19');
  103. INSERT INTO z5_faktury VALUES(101,'Hanna','Hankiewicz','Towar C',30,3,'2019-08-18');
  104. INSERT INTO z5_faktury VALUES(102,'Julia','Julkiewicz','Towar B',20,7,'2019-08-17');
  105. INSERT INTO z5_faktury VALUES(103,'Gracjan','Grakiewicz','Towar C',30,4,'2019-08-16');
  106. INSERT INTO z5_faktury VALUES(104,'Zofia','Zofkiewicz','Towar B',20,11,'2019-08-15');
  107. INSERT INTO z5_faktury VALUES(105,'Piotr','Piokiewicz','Towar A',10,2,'2019-08-14');
  108. INSERT INTO z5_faktury VALUES(106,'Antoni','Antkiewicz','Towar B',20,5,'2019-08-13');
  109. INSERT INTO z5_faktury VALUES(107,'Dominika','Domkiewicz','Towar B',20,4,'2019-08-12');
  110. INSERT INTO z5_faktury VALUES(108,'Julian','Julkiewicz','Towar A',10,5,'2019-08-11');
  111. INSERT INTO z5_faktury VALUES(109,'Martyna','Markiewicz','Towar A',10,10,'2019-08-10');
  112. INSERT INTO z5_faktury VALUES(110,'Arleta','Arlkiewicz','Towar A',10,9,'2019-08-09');
  113. INSERT INTO z5_faktury VALUES(111,'Petronella','Petkiewicz','Towar A',10,1,'2019-08-08');
  114. INSERT INTO z5_faktury VALUES(112,'Teresa','Terkiewicz','Towar A',10,6,'2019-08-07');
  115. INSERT INTO z5_faktury VALUES(113,'Lucyna','Luckiewicz','Towar B',20,7,'2019-08-06');
  116. INSERT INTO z5_faktury VALUES(114,'Maksymilian','Makkiewicz','Towar A',10,9,'2019-08-05');
  117. INSERT INTO z5_faktury VALUES(115,'Magdalena','Magkiewicz','Towar B',20,8,'2019-08-04');
  118. INSERT INTO z5_faktury VALUES(116,'Martyna','Markiewicz','Towar C',30,8,'2019-08-03');
  119. INSERT INTO z5_faktury VALUES(117,'Julia','Julkiewicz','Towar B',20,10,'2019-08-02');
  120. INSERT INTO z5_faktury VALUES(118,'Arleta','Arlkiewicz','Towar B',20,6,'2019-08-01');
  121. INSERT INTO z5_faktury VALUES(119,'Stanisław','Stakiewicz','Towar C',30,9,'2019-07-31');
  122. INSERT INTO z5_faktury VALUES(120,'Maksymilian','Makkiewicz','Towar B',20,8,'2019-07-30');
  123. INSERT INTO z5_faktury VALUES(121,'Wiliam','Wilkiewicz','Towar A',10,8,'2019-07-29');
  124. INSERT INTO z5_faktury VALUES(122,'Marcjanna','Markiewicz','Towar B',20,7,'2019-07-28');
  125. INSERT INTO z5_faktury VALUES(123,'Aleksander','Alekiewicz','Towar B',20,2,'2019-07-27');
  126. INSERT INTO z5_faktury VALUES(124,'Izabela','Izakiewicz','Towar C',30,1,'2019-07-26');
  127. INSERT INTO z5_faktury VALUES(125,'Piotr','Piokiewicz','Towar A',10,2,'2019-07-25');
  128. INSERT INTO z5_faktury VALUES(126,'Agnieszka','Agnkiewicz','Towar C',30,3,'2019-07-24');
  129. INSERT INTO z5_faktury VALUES(127,'Agnieszka','Agnkiewicz','Towar B',20,5,'2019-07-23');
  130. INSERT INTO z5_faktury VALUES(128,'Aneta','Anekiewicz','Towar C',30,9,'2019-07-22');
  131. INSERT INTO z5_faktury VALUES(129,'Odetta','Odekiewicz','Towar C',30,9,'2019-07-21');
  132. INSERT INTO z5_faktury VALUES(130,'Andrzej','Andkiewicz','Towar B',20,5,'2019-07-20');
  133. INSERT INTO z5_faktury VALUES(131,'Ariana','Arikiewicz','Towar C',30,6,'2019-07-19');
  134. INSERT INTO z5_faktury VALUES(132,'Joanna','Joakiewicz','Towar A',10,3,'2019-07-18');
  135. INSERT INTO z5_faktury VALUES(133,'Sylwia','Sylkiewicz','Towar A',10,1,'2019-07-17');
  136. INSERT INTO z5_faktury VALUES(134,'Irena','Irekiewicz','Towar C',30,10,'2019-07-16');
  137. INSERT INTO z5_faktury VALUES(135,'Bogumiła','Bogkiewicz','Towar B',20,4,'2019-07-15');
  138. INSERT INTO z5_faktury VALUES(136,'Bogumiła','Bogkiewicz','Towar A',10,6,'2019-07-14');
  139. INSERT INTO z5_faktury VALUES(137,'Adrianna','Adrkiewicz','Towar A',10,3,'2019-07-13');
  140. INSERT INTO z5_faktury VALUES(138,'Magdalena','Magkiewicz','Towar B',20,6,'2019-07-12');
  141. INSERT INTO z5_faktury VALUES(139,'Bogumiła','Bogkiewicz','Towar C',30,5,'2019-07-11');
  142. INSERT INTO z5_faktury VALUES(140,'Dominika','Domkiewicz','Towar B',20,5,'2019-07-10');
  143. INSERT INTO z5_faktury VALUES(141,'Izabela','Izakiewicz','Towar B',20,10,'2019-07-09');
  144. INSERT INTO z5_faktury VALUES(142,'Paweł','Pawkiewicz','Towar B',20,2,'2019-07-08');
  145. INSERT INTO z5_faktury VALUES(143,'Jagoda','Jagkiewicz','Towar B',20,2,'2019-07-07');
  146. INSERT INTO z5_faktury VALUES(144,'Ariana','Arikiewicz','Towar C',30,8,'2019-07-06');
  147. INSERT INTO z5_faktury VALUES(145,'Krzysztof','Krzkiewicz','Towar B',20,2,'2019-07-05');
  148. INSERT INTO z5_faktury VALUES(146,'Mirella','Mirkiewicz','Towar A',10,4,'2019-07-04');
  149. INSERT INTO z5_faktury VALUES(147,'Marika','Markiewicz','Towar B',20,2,'2019-07-03');
  150. INSERT INTO z5_faktury VALUES(148,'Nikola','Nikkiewicz','Towar A',10,4,'2019-07-02');
  151. INSERT INTO z5_faktury VALUES(149,'Jacek','Jackiewicz','Towar B',20,5,'2019-07-01');
  152. INSERT INTO z5_faktury VALUES(150,'Natan','Natkiewicz','Towar A',10,7,'2019-06-30');
  153. INSERT INTO z5_faktury VALUES(151,'Bernadetta','Berkiewicz','Towar B',20,7,'2019-06-29');
  154. INSERT INTO z5_faktury VALUES(152,'Anna','Annkiewicz','Towar B',20,6,'2019-06-28');
  155. INSERT INTO z5_faktury VALUES(153,'Andrzej','Andkiewicz','Towar C',30,6,'2019-06-27');
  156. INSERT INTO z5_faktury VALUES(154,'Wioleta','Wiokiewicz','Towar B',20,2,'2019-06-26');
  157. INSERT INTO z5_faktury VALUES(155,'Helena','Helkiewicz','Towar A',10,11,'2019-06-25');
  158. INSERT INTO z5_faktury VALUES(156,'Paweł','Pawkiewicz','Towar C',30,6,'2019-06-24');
  159. INSERT INTO z5_faktury VALUES(157,'Jan','Jankiewicz','Towar B',20,2,'2019-06-23');
  160. INSERT INTO z5_faktury VALUES(158,'Pamela','Pamkiewicz','Towar B',20,11,'2019-06-22');
  161. INSERT INTO z5_faktury VALUES(159,'Odetta','Odekiewicz','Towar B',20,7,'2019-06-21');
  162. INSERT INTO z5_faktury VALUES(160,'Jagoda','Jagkiewicz','Towar A',10,11,'2019-06-20');
  163. INSERT INTO z5_faktury VALUES(161,'Agnieszka','Agnkiewicz','Towar A',10,5,'2019-06-19');
  164. INSERT INTO z5_faktury VALUES(162,'Krzysztof','Krzkiewicz','Towar A',10,10,'2019-06-18');
  165. INSERT INTO z5_faktury VALUES(163,'Marcjanna','Markiewicz','Towar B',20,7,'2019-06-17');
  166. INSERT INTO z5_faktury VALUES(164,'Krzysztof','Krzkiewicz','Towar B',20,6,'2019-06-16');
  167. INSERT INTO z5_faktury VALUES(165,'Dominika','Domkiewicz','Towar A',10,8,'2019-06-15');
  168. INSERT INTO z5_faktury VALUES(166,'Petronella','Petkiewicz','Towar B',20,5,'2019-06-14');
  169. INSERT INTO z5_faktury VALUES(167,'Wincenty','Winkiewicz','Towar B',20,4,'2019-06-13');
  170. INSERT INTO z5_faktury VALUES(168,'Arkadiusz','Arkkiewicz','Towar C',30,2,'2019-06-12');
  171. INSERT INTO z5_faktury VALUES(169,'Wioleta','Wiokiewicz','Towar A',10,7,'2019-06-11');
  172. INSERT INTO z5_faktury VALUES(170,'Kamila','Kamkiewicz','Towar B',20,4,'2019-06-10');
  173. INSERT INTO z5_faktury VALUES(171,'Irena','Irekiewicz','Towar A',10,4,'2019-06-09');
  174. INSERT INTO z5_faktury VALUES(172,'Maciej','Mackiewicz','Towar A',10,9,'2019-06-08');
  175. INSERT INTO z5_faktury VALUES(173,'Arleta','Arlkiewicz','Towar B',20,6,'2019-06-07');
  176. INSERT INTO z5_faktury VALUES(174,'Antonina','Antkiewicz','Towar B',20,6,'2019-06-06');
  177. INSERT INTO z5_faktury VALUES(175,'Paweł','Pawkiewicz','Towar B',20,10,'2019-06-05');
  178. INSERT INTO z5_faktury VALUES(176,'Wiliam','Wilkiewicz','Towar A',10,11,'2019-06-04');
  179. INSERT INTO z5_faktury VALUES(177,'Katarzyna','Katkiewicz','Towar A',10,4,'2019-06-03');
  180. INSERT INTO z5_faktury VALUES(178,'Zbigniew','Zbikiewicz','Towar B',20,6,'2019-06-02');
  181. INSERT INTO z5_faktury VALUES(179,'Marcjanna','Markiewicz','Towar B',20,4,'2019-06-01');
  182. INSERT INTO z5_faktury VALUES(180,'Agnieszka','Agnkiewicz','Towar B',20,2,'2019-05-31');
  183. INSERT INTO z5_faktury VALUES(181,'Maciej','Mackiewicz','Towar C',30,7,'2019-05-30');
  184. INSERT INTO z5_faktury VALUES(182,'Martyna','Markiewicz','Towar B',20,5,'2019-05-29');
  185. INSERT INTO z5_faktury VALUES(183,'Krystyna','Krykiewicz','Towar B',20,5,'2019-05-28');
  186. INSERT INTO z5_faktury VALUES(184,'Mirella','Mirkiewicz','Towar C',30,5,'2019-05-27');
  187. INSERT INTO z5_faktury VALUES(185,'Marika','Markiewicz','Towar C',30,2,'2019-05-26');
  188. INSERT INTO z5_faktury VALUES(186,'Zbigniew','Zbikiewicz','Towar C',30,9,'2019-05-25');
  189. INSERT INTO z5_faktury VALUES(187,'Jacek','Jackiewicz','Towar C',30,7,'2019-05-24');
  190. INSERT INTO z5_faktury VALUES(188,'Paweł','Pawkiewicz','Towar A',10,6,'2019-05-23');
  191. INSERT INTO z5_faktury VALUES(189,'Dorota','Dorkiewicz','Towar B',20,4,'2019-05-22');
  192. INSERT INTO z5_faktury VALUES(190,'Wincenty','Winkiewicz','Towar B',20,2,'2019-05-21');
  193. INSERT INTO z5_faktury VALUES(191,'Marzena','Markiewicz','Towar B',20,8,'2019-05-20');
  194. INSERT INTO z5_faktury VALUES(192,'Jagoda','Jagkiewicz','Towar B',20,9,'2019-05-19');
  195. INSERT INTO z5_faktury VALUES(193,'Adrianna','Adrkiewicz','Towar B',20,6,'2019-05-18');
  196. INSERT INTO z5_faktury VALUES(194,'Maria','Markiewicz','Towar A',10,2,'2019-05-17');
  197. INSERT INTO z5_faktury VALUES(195,'Zbigniew','Zbikiewicz','Towar C',30,8,'2019-05-16');
  198. INSERT INTO z5_faktury VALUES(196,'Arkadiusz','Arkkiewicz','Towar B',20,7,'2019-05-15');
  199. INSERT INTO z5_faktury VALUES(197,'Aneta','Anekiewicz','Towar A',10,4,'2019-05-14');
  200. INSERT INTO z5_faktury VALUES(198,'Maciej','Mackiewicz','Towar A',10,3,'2019-05-13');
  201. INSERT INTO z5_faktury VALUES(199,'Marcjanna','Markiewicz','Towar B',20,9,'2019-05-12');
  202. INSERT INTO z5_faktury VALUES(200,'Jacek','Jackiewicz','Towar B',20,11,'2019-05-11');
  203. INSERT INTO z5_faktury VALUES(201,'Julian','Julkiewicz','Towar A',10,3,'2019-05-10');
  204. INSERT INTO z5_faktury VALUES(202,'Albin','Albkiewicz','Towar C',30,3,'2019-05-09');
  205. INSERT INTO z5_faktury VALUES(203,'Magdalena','Magkiewicz','Towar B',20,7,'2019-05-08');
  206. INSERT INTO z5_faktury VALUES(204,'Teresa','Terkiewicz','Towar B',20,7,'2019-05-07');
  207. INSERT INTO z5_faktury VALUES(205,'Andrzej','Andkiewicz','Towar A',10,10,'2019-05-06');
  208. INSERT INTO z5_faktury VALUES(206,'Anna','Annkiewicz','Towar B',20,3,'2019-05-05');
  209. INSERT INTO z5_faktury VALUES(207,'Helena','Helkiewicz','Towar C',30,9,'2019-05-04');
  210. INSERT INTO z5_faktury VALUES(208,'Zuzanna','Zuzkiewicz','Towar B',20,6,'2019-05-03');
  211. INSERT INTO z5_faktury VALUES(209,'Jagna','Jagkiewicz','Towar B',20,6,'2019-05-02');
  212. INSERT INTO z5_faktury VALUES(210,'Wojciech','Wojkiewicz','Towar B',20,5,'2019-05-01');
  213. INSERT INTO z5_faktury VALUES(211,'Zuzanna','Zuzkiewicz','Towar C',30,7,'2019-04-30');
  214. INSERT INTO z5_faktury VALUES(212,'Antoni','Antkiewicz','Towar A',10,4,'2019-04-29');
  215. INSERT INTO z5_faktury VALUES(213,'Wioleta','Wiokiewicz','Towar B',20,6,'2019-04-28');
  216. INSERT INTO z5_faktury VALUES(214,'Wincenty','Winkiewicz','Towar C',30,2,'2019-04-27');
  217. INSERT INTO z5_faktury VALUES(215,'Krystyna','Krykiewicz','Towar C',30,7,'2019-04-26');
  218. INSERT INTO z5_faktury VALUES(216,'Kamila','Kamkiewicz','Towar C',30,5,'2019-04-25');
  219. INSERT INTO z5_faktury VALUES(217,'Gracjan','Grakiewicz','Towar A',10,10,'2019-04-24');
  220. INSERT INTO z5_faktury VALUES(218,'Jadwiga','Jadkiewicz','Towar C',30,4,'2019-04-23');
  221. INSERT INTO z5_faktury VALUES(219,'Marika','Markiewicz','Towar B',20,7,'2019-04-22');
  222. INSERT INTO z5_faktury VALUES(220,'Józef','Józkiewicz','Towar B',20,2,'2019-04-21');
  223. INSERT INTO z5_faktury VALUES(221,'Bożena','Bożkiewicz','Towar A',10,6,'2019-04-20');
  224. INSERT INTO z5_faktury VALUES(222,'Anna','Annkiewicz','Towar A',10,3,'2019-04-19');
  225. INSERT INTO z5_faktury VALUES(223,'Lucyna','Luckiewicz','Towar B',20,8,'2019-04-18');
  226. INSERT INTO z5_faktury VALUES(224,'Adrianna','Adrkiewicz','Towar B',20,9,'2019-04-17');
  227. INSERT INTO z5_faktury VALUES(225,'Dorota','Dorkiewicz','Towar B',20,5,'2019-04-16');
  228. INSERT INTO z5_faktury VALUES(226,'Teresa','Terkiewicz','Towar B',20,7,'2019-04-15');
  229. INSERT INTO z5_faktury VALUES(227,'Anna','Annkiewicz','Towar C',30,7,'2019-04-14');
  230. INSERT INTO z5_faktury VALUES(228,'Gracjan','Grakiewicz','Towar B',20,5,'2019-04-13');
  231. INSERT INTO z5_faktury VALUES(229,'Julian','Julkiewicz','Towar B',20,9,'2019-04-12');
  232. INSERT INTO z5_faktury VALUES(230,'Jan','Jankiewicz','Towar B',20,10,'2019-04-11');
  233. INSERT INTO z5_faktury VALUES(231,'Jadwiga','Jadkiewicz','Towar B',20,10,'2019-04-10');
  234. INSERT INTO z5_faktury VALUES(232,'Natan','Natkiewicz','Towar B',20,7,'2019-04-09');
  235. INSERT INTO z5_faktury VALUES(233,'Ariana','Arikiewicz','Towar C',30,11,'2019-04-08');
  236. INSERT INTO z5_faktury VALUES(234,'Zofia','Zofkiewicz','Towar B',20,7,'2019-04-07');
  237. INSERT INTO z5_faktury VALUES(235,'Irena','Irekiewicz','Towar B',20,2,'2019-04-06');
  238. INSERT INTO z5_faktury VALUES(236,'Szymon','Szykiewicz','Towar A',10,3,'2019-04-05');
  239. INSERT INTO z5_faktury VALUES(237,'Hanna','Hankiewicz','Towar A',10,11,'2019-04-04');
  240. INSERT INTO z5_faktury VALUES(238,'Antoni','Antkiewicz','Towar B',20,7,'2019-04-03');
  241. INSERT INTO z5_faktury VALUES(239,'Szymon','Szykiewicz','Towar B',20,10,'2019-04-02');
  242. INSERT INTO z5_faktury VALUES(240,'Wiliam','Wilkiewicz','Towar B',20,8,'2019-04-01');
  243. INSERT INTO z5_faktury VALUES(241,'Antoni','Antkiewicz','Towar A',10,6,'2019-03-31');
  244. INSERT INTO z5_faktury VALUES(242,'Franciszek','Frakiewicz','Towar C',30,1,'2019-03-30');
  245. INSERT INTO z5_faktury VALUES(243,'Sylwia','Sylkiewicz','Towar B',20,11,'2019-03-29');
  246. INSERT INTO z5_faktury VALUES(244,'Józef','Józkiewicz','Towar B',20,5,'2019-03-28');
  247. INSERT INTO z5_faktury VALUES(245,'Jagna','Jagkiewicz','Towar B',20,1,'2019-03-27');
  248. INSERT INTO z5_faktury VALUES(246,'Dorota','Dorkiewicz','Towar B',20,2,'2019-03-26');
  249. INSERT INTO z5_faktury VALUES(247,'Stanisław','Stakiewicz','Towar A',10,7,'2019-03-25');
  250. INSERT INTO z5_faktury VALUES(248,'Odetta','Odekiewicz','Towar B',20,1,'2019-03-24');
  251. INSERT INTO z5_faktury VALUES(249,'Teresa','Terkiewicz','Towar C',30,3,'2019-03-23');
  252. INSERT INTO z5_faktury VALUES(250,'Gracjan','Grakiewicz','Towar A',10,7,'2019-03-22');
  253. INSERT INTO z5_faktury VALUES(251,'Marcin','Markiewicz','Towar B',20,10,'2019-03-21');
  254. INSERT INTO z5_faktury VALUES(252,'Zofia','Zofkiewicz','Towar B',20,7,'2019-03-20');
  255. INSERT INTO z5_faktury VALUES(253,'Aleksander','Alekiewicz','Towar A',10,7,'2019-03-19');
  256. INSERT INTO z5_faktury VALUES(254,'Zofia','Zofkiewicz','Towar C',30,6,'2019-03-18');
  257. INSERT INTO z5_faktury VALUES(255,'Wojciech','Wojkiewicz','Towar A',10,6,'2019-03-17');
  258. INSERT INTO z5_faktury VALUES(256,'Katarzyna','Katkiewicz','Towar A',10,4,'2019-03-16');
  259. INSERT INTO z5_faktury VALUES(257,'Irena','Irekiewicz','Towar B',20,6,'2019-03-15');
  260. INSERT INTO z5_faktury VALUES(258,'Katarzyna','Katkiewicz','Towar B',20,5,'2019-03-14');
  261. INSERT INTO z5_faktury VALUES(259,'Katarzyna','Katkiewicz','Towar C',30,11,'2019-03-13');
  262. INSERT INTO z5_faktury VALUES(260,'Albin','Albkiewicz','Towar B',20,4,'2019-03-12');
  263. INSERT INTO z5_faktury VALUES(261,'Aleksander','Alekiewicz','Towar A',10,1,'2019-03-11');
  264. INSERT INTO z5_faktury VALUES(262,'Arleta','Arlkiewicz','Towar A',10,7,'2019-03-10');
  265. INSERT INTO z5_faktury VALUES(263,'Pamela','Pamkiewicz','Towar B',20,4,'2019-03-09');
  266. INSERT INTO z5_faktury VALUES(264,'Albin','Albkiewicz','Towar B',20,10,'2019-03-08');
  267. INSERT INTO z5_faktury VALUES(265,'Marika','Markiewicz','Towar A',10,7,'2019-03-07');
  268. INSERT INTO z5_faktury VALUES(266,'Sylwia','Sylkiewicz','Towar B',20,4,'2019-03-06');
  269. INSERT INTO z5_faktury VALUES(267,'Hanna','Hankiewicz','Towar C',30,9,'2019-03-05');
  270. INSERT INTO z5_faktury VALUES(268,'Stanisław','Stakiewicz','Towar A',10,11,'2019-03-04');
  271. INSERT INTO z5_faktury VALUES(269,'Natan','Natkiewicz','Towar A',10,5,'2019-03-03');
  272. INSERT INTO z5_faktury VALUES(270,'Albin','Albkiewicz','Towar A',10,9,'2019-03-02');
  273. INSERT INTO z5_faktury VALUES(271,'Maria','Markiewicz','Towar B',20,2,'2019-03-01');
  274. INSERT INTO z5_faktury VALUES(272,'Jagoda','Jagkiewicz','Towar C',30,9,'2019-02-28');
  275. INSERT INTO z5_faktury VALUES(273,'Helena','Helkiewicz','Towar B',20,10,'2019-02-27');
  276. INSERT INTO z5_faktury VALUES(274,'Jan','Jankiewicz','Towar B',20,5,'2019-02-26');
  277. INSERT INTO z5_faktury VALUES(275,'Maciej','Mackiewicz','Towar A',10,1,'2019-02-25');
  278. INSERT INTO z5_faktury VALUES(276,'Szymon','Szykiewicz','Towar C',30,4,'2019-02-24');
  279.  
  280. CREATE TABLE z5_zamowienia(nr_zamowienia int NOT NULL AUTO_INCREMENT PRIMARY KEY, nr_klienta int, nr_towaru int, sztuki int, data_zamowienia varchar(100));
  281. CREATE TABLE z5_towary(nr_towaru int NOT NULL AUTO_INCREMENT PRIMARY KEY, nazwa varchar(100), cena int);
  282. CREATE TABLE z5_klienci(nr_klienta int NOT NULL AUTO_INCREMENT PRIMARY KEY, imie varchar(50), nazwisko varchar(100));
  283.  
  284. ALTER TABLE z5_zamowienia
  285. ADD FOREIGN KEY (nr_klienta) REFERENCES z5_klienci(nr_klienta);
  286.  
  287. ALTER TABLE z5_zamowienia
  288. ADD FOREIGN KEY (nr_towaru) REFERENCES z5_towary(nr_towaru);
  289.  
  290. INSERT INTO z5_towary(nazwa, cena) SELECT DISTINCT towar, cena from z5_faktury;
  291. INSERT INTO z5_klienci(imie, nazwisko) SELECT DISTINCT imie, nazwisko from z5_faktury;
  292.  
  293. INSERT INTO z5_zamowienia(nr_zamowienia, nr_klienta, sztuki, data_zamowienia) SELECT z5_faktury.nr_zamowienia, z5_klienci.nr_klienta, z5_faktury.sztuki, z5_faktury.data_zamowienia from z5_faktury join z5_klienci on z5_faktury.imie = z5_klienci.imie OR z5_faktury.nazwisko = z5_klienci.nazwisko GROUP BY z5_faktury.nr_zamowienia;
  294.  
  295. UPDATE z5_zamowienia
  296. JOIN z5_faktury ON z5_zamowienia.nr_zamowienia = z5_faktury.nr_zamowienia
  297. JOIN z5_towary ON z5_faktury.towar = z5_towary.nazwa
  298. SET z5_zamowienia.nr_towaru = z5_towary.nr_towaru;
  299.  
  300. INSERT INTO z5_zamowienia VALUES(0, 23, 1, 10, '2019-11-27');
  301. INSERT INTO z5_zamowienia VALUES(0, 23, 2, 5, '2019-11-28');
  302. INSERT INTO z5_zamowienia VALUES(0, 23, 2, 3, '2019-11-29');
  303. INSERT INTO z5_zamowienia VALUES(0, 23, 3, 4, '2019-11-30');
  304. INSERT INTO z5_zamowienia VALUES(0, 23, 3, 1, '2019-11-29');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!