API tools faq
paste
Advertisement
wa12rior

z5 b przer

wa12rior
Nov 27th, 2019
164
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 19.85 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE tran(nr_zamowienia int NOT NULL AUTO_INCREMENT PRIMARY KEY, imie varchar(50), towar varchar(50), cena int, sztuki int, data date);
  2.  
  3. INSERT INTO tran VALUES(1,'Adrianna','Towar B',20,2,'2019-11-25');
  4. INSERT INTO tran VALUES(2,'Adrianna','Towar C',30,11,'2019-11-25');
  5. INSERT INTO tran VALUES(3,'Adrianna','Towar A',10,6,'2019-11-26');
  6. INSERT INTO tran VALUES(4,'Adrianna','Towar C',30,7,'2019-11-25');
  7. INSERT INTO tran VALUES(5,'Agnieszka','Towar C',30,3,'2019-11-25');
  8. INSERT INTO tran VALUES(6,'Agnieszka','Towar B',20,3,'2019-11-25');
  9. INSERT INTO tran VALUES(7,'Agnieszka','Towar B',20,10,'2019-11-25');
  10. INSERT INTO tran VALUES(8,'Agnieszka','Towar C',30,1,'2019-11-25');
  11. INSERT INTO tran VALUES(9,'Albin','Towar A',10,5,'2019-11-26');
  12. INSERT INTO tran VALUES(10,'Albin','Towar B',20,9,'2019-11-25');
  13. INSERT INTO tran VALUES(11,'Albin','Towar A',10,10,'2019-11-26');
  14. INSERT INTO tran VALUES(12,'Albin','Towar B',20,10,'2019-11-25');
  15. INSERT INTO tran VALUES(13,'Aleksander','Towar A',10,1,'2019-11-26');
  16. INSERT INTO tran VALUES(14,'Aleksander','Towar C',30,10,'2019-11-25');
  17. INSERT INTO tran VALUES(15,'Aleksander','Towar B',20,8,'2019-11-25');
  18. INSERT INTO tran VALUES(16,'Aleksander','Towar B',20,7,'2019-11-25');
  19. INSERT INTO tran VALUES(17,'Andrzej','Towar B',20,5,'2019-11-25');
  20. INSERT INTO tran VALUES(18,'Andrzej','Towar A',10,9,'2019-11-26');
  21. INSERT INTO tran VALUES(19,'Andrzej','Towar B',20,8,'2019-11-25');
  22. INSERT INTO tran VALUES(20,'Andrzej','Towar B',20,9,'2019-11-25');
  23. INSERT INTO tran VALUES(21,'Aneta','Towar C',30,6,'2019-11-25');
  24. INSERT INTO tran VALUES(22,'Aneta','Towar A',10,7,'2019-11-26');
  25. INSERT INTO tran VALUES(23,'Aneta','Towar C',30,7,'2019-11-25');
  26. INSERT INTO tran VALUES(24,'Aneta','Towar B',20,10,'2019-11-25');
  27. INSERT INTO tran VALUES(25,'Anna','Towar C',30,1,'2019-11-25');
  28. INSERT INTO tran VALUES(26,'Anna','Towar B',20,6,'2019-11-25');
  29. INSERT INTO tran VALUES(27,'Anna','Towar B',20,6,'2019-11-25');
  30. INSERT INTO tran VALUES(28,'Anna','Towar B',20,5,'2019-11-25');
  31. INSERT INTO tran VALUES(29,'Antoni','Towar B',20,6,'2019-11-25');
  32. INSERT INTO tran VALUES(30,'Antoni','Towar B',20,4,'2019-11-25');
  33. INSERT INTO tran VALUES(31,'Antoni','Towar B',20,10,'2019-11-25');
  34. INSERT INTO tran VALUES(32,'Antoni','Towar B',20,7,'2019-11-25');
  35. INSERT INTO tran VALUES(33,'Antonina','Towar B',20,4,'2019-11-25');
  36. INSERT INTO tran VALUES(34,'Antonina','Towar A',10,3,'2019-11-26');
  37. INSERT INTO tran VALUES(35,'Antonina','Towar C',30,6,'2019-11-25');
  38. INSERT INTO tran VALUES(36,'Antonina','Towar B',20,2,'2019-11-25');
  39. INSERT INTO tran VALUES(37,'Ariana','Towar B',20,4,'2019-11-25');
  40. INSERT INTO tran VALUES(38,'Ariana','Towar B',20,5,'2019-11-25');
  41. INSERT INTO tran VALUES(39,'Ariana','Towar B',20,1,'2019-11-25');
  42. INSERT INTO tran VALUES(40,'Ariana','Towar B',20,8,'2019-11-25');
  43. INSERT INTO tran VALUES(41,'Arkadiusz','Towar A',10,4,'2019-11-26');
  44. INSERT INTO tran VALUES(42,'Arkadiusz','Towar A',10,4,'2019-11-26');
  45. INSERT INTO tran VALUES(43,'Arkadiusz','Towar A',10,8,'2019-11-26');
  46. INSERT INTO tran VALUES(44,'Arkadiusz','Towar B',20,8,'2019-11-25');
  47. INSERT INTO tran VALUES(45,'Arleta','Towar A',10,3,'2019-11-26');
  48. INSERT INTO tran VALUES(46,'Arleta','Towar A',10,10,'2019-11-26');
  49. INSERT INTO tran VALUES(47,'Arleta','Towar B',20,10,'2019-11-25');
  50. INSERT INTO tran VALUES(48,'Arleta','Towar B',20,5,'2019-11-25');
  51. INSERT INTO tran VALUES(49,'Bernadetta','Towar B',20,2,'2019-11-25');
  52. INSERT INTO tran VALUES(50,'Bernadetta','Towar A',10,9,'2019-11-26');
  53. INSERT INTO tran VALUES(51,'Bernadetta','Towar B',20,3,'2019-11-25');
  54. INSERT INTO tran VALUES(52,'Bernadetta','Towar B',20,10,'2019-11-25');
  55. INSERT INTO tran VALUES(53,'Bogumiła','Towar B',20,4,'2019-11-25');
  56. INSERT INTO tran VALUES(54,'Bogumiła','Towar B',20,11,'2019-11-25');
  57. INSERT INTO tran VALUES(55,'Bogumiła','Towar B',20,10,'2019-11-25');
  58. INSERT INTO tran VALUES(56,'Bogumiła','Towar B',20,4,'2019-11-25');
  59. INSERT INTO tran VALUES(57,'Bożena','Towar C',30,10,'2019-11-25');
  60. INSERT INTO tran VALUES(58,'Bożena','Towar A',10,2,'2019-11-26');
  61. INSERT INTO tran VALUES(59,'Bożena','Towar C',30,1,'2019-11-25');
  62. INSERT INTO tran VALUES(60,'Bożena','Towar B',20,7,'2019-11-25');
  63. INSERT INTO tran VALUES(61,'Dominika','Towar C',30,9,'2019-11-25');
  64. INSERT INTO tran VALUES(62,'Dominika','Towar B',20,10,'2019-11-25');
  65. INSERT INTO tran VALUES(63,'Dominika','Towar B',20,5,'2019-11-25');
  66. INSERT INTO tran VALUES(64,'Dominika','Towar B',20,2,'2019-11-25');
  67. INSERT INTO tran VALUES(65,'Dorota','Towar B',20,2,'2019-11-25');
  68. INSERT INTO tran VALUES(66,'Dorota','Towar A',10,6,'2019-11-26');
  69. INSERT INTO tran VALUES(67,'Dorota','Towar B',20,7,'2019-11-25');
  70. INSERT INTO tran VALUES(68,'Dorota','Towar B',20,9,'2019-11-25');
  71. INSERT INTO tran VALUES(69,'Franciszek','Towar B',20,3,'2019-11-25');
  72. INSERT INTO tran VALUES(70,'Franciszek','Towar C',30,8,'2019-11-25');
  73. INSERT INTO tran VALUES(71,'Franciszek','Towar C',30,3,'2019-11-25');
  74. INSERT INTO tran VALUES(72,'Franciszek','Towar A',10,3,'2019-11-26');
  75. INSERT INTO tran VALUES(73,'Gracjan','Towar C',30,9,'2019-11-25');
  76. INSERT INTO tran VALUES(74,'Gracjan','Towar B',20,6,'2019-11-25');
  77. INSERT INTO tran VALUES(75,'Gracjan','Towar B',20,7,'2019-11-25');
  78. INSERT INTO tran VALUES(76,'Gracjan','Towar B',20,7,'2019-11-25');
  79. INSERT INTO tran VALUES(77,'Hanna','Towar A',10,9,'2019-11-26');
  80. INSERT INTO tran VALUES(78,'Hanna','Towar C',30,8,'2019-11-25');
  81. INSERT INTO tran VALUES(79,'Hanna','Towar B',20,11,'2019-11-25');
  82. INSERT INTO tran VALUES(80,'Hanna','Towar B',20,11,'2019-11-25');
  83. INSERT INTO tran VALUES(81,'Helena','Towar A',10,7,'2019-11-26');
  84. INSERT INTO tran VALUES(82,'Helena','Towar B',20,7,'2019-11-25');
  85. INSERT INTO tran VALUES(83,'Helena','Towar A',10,10,'2019-11-26');
  86. INSERT INTO tran VALUES(84,'Helena','Towar B',20,5,'2019-11-25');
  87. INSERT INTO tran VALUES(85,'Irena','Towar B',20,7,'2019-11-25');
  88. INSERT INTO tran VALUES(86,'Irena','Towar B',20,9,'2019-11-25');
  89. INSERT INTO tran VALUES(87,'Irena','Towar B',20,4,'2019-11-25');
  90. INSERT INTO tran VALUES(88,'Irena','Towar C',30,2,'2019-11-25');
  91. INSERT INTO tran VALUES(89,'Izabela','Towar B',20,6,'2019-11-25');
  92. INSERT INTO tran VALUES(90,'Izabela','Towar C',30,4,'2019-11-25');
  93. INSERT INTO tran VALUES(91,'Izabela','Towar C',30,10,'2019-11-25');
  94. INSERT INTO tran VALUES(92,'Izabela','Towar C',30,8,'2019-11-25');imie
  95. INSERT INTO tran VALUES(93,'Jacek','Towar B',20,6,'2019-11-25');
  96. INSERT INTO tran VALUES(94,'Jacek','Towar A',10,8,'2019-11-26');
  97. INSERT INTO tran VALUES(95,'Jacek','Towar B',20,1,'2019-11-25');
  98. INSERT INTO tran VALUES(96,'Jacek','Towar B',20,11,'2019-11-25');
  99. INSERT INTO tran VALUES(97,'Jadwiga','Towar A',10,4,'2019-11-26');
  100. INSERT INTO tran VALUES(98,'Jadwiga','Towar A',10,3,'2019-11-26');
  101. INSERT INTO tran VALUES(99,'Jadwiga','Towar B',20,10,'2019-11-25');
  102. INSERT INTO tran VALUES(100,'Jadwiga','Towar B',20,4,'2019-11-25');
  103. INSERT INTO tran VALUES(101,'Jagna','Towar C',30,6,'2019-11-25');
  104. INSERT INTO tran VALUES(102,'Jagna','Towar A',10,7,'2019-11-26');
  105. INSERT INTO tran VALUES(103,'Jagna','Towar B',20,6,'2019-11-25');
  106. INSERT INTO tran VALUES(104,'Jagna','Towar B',20,1,'2019-11-25');
  107. INSERT INTO tran VALUES(105,'Jagoda','Towar B',20,8,'2019-11-25');
  108. INSERT INTO tran VALUES(106,'Jagoda','Towar B',20,3,'2019-11-25');
  109. INSERT INTO tran VALUES(107,'Jagoda','Towar C',30,10,'2019-11-25');
  110. INSERT INTO tran VALUES(108,'Jagoda','Towar B',20,3,'2019-11-25');
  111. INSERT INTO tran VALUES(109,'Jan','Towar B',20,11,'2019-11-25');
  112. INSERT INTO tran VALUES(110,'Jan','Towar B',20,7,'2019-11-25');
  113. INSERT INTO tran VALUES(111,'Jan','Towar B',20,10,'2019-11-25');
  114. INSERT INTO tran VALUES(112,'Jan','Towar B',20,3,'2019-11-25');
  115. INSERT INTO tran VALUES(113,'Joanna','Towar A',10,3,'2019-11-26');
  116. INSERT INTO tran VALUES(114,'Joanna','Towar C',30,5,'2019-11-25');
  117. INSERT INTO tran VALUES(115,'Joanna','Towar A',10,5,'2019-11-26');
  118. INSERT INTO tran VALUES(116,'Joanna','Towar B',20,6,'2019-11-25');
  119. INSERT INTO tran VALUES(117,'Jozue','Towar B',20,11,'2019-11-25');
  120. INSERT INTO tran VALUES(118,'Jozue','Towar B',20,8,'2019-11-25');
  121. INSERT INTO tran VALUES(119,'Jozue','Towar A',10,8,'2019-11-26');
  122. INSERT INTO tran VALUES(120,'Jozue','Towar A',10,8,'2019-11-26');
  123. INSERT INTO tran VALUES(121,'Józef','Towar A',10,3,'2019-11-26');
  124. INSERT INTO tran VALUES(122,'Józef','Towar B',20,11,'2019-11-25');
  125. INSERT INTO tran VALUES(123,'Józef','Towar C',30,11,'2019-11-25');
  126. INSERT INTO tran VALUES(124,'Józef','Towar B',20,8,'2019-11-25');
  127. INSERT INTO tran VALUES(125,'Julia','Towar C',30,1,'2019-11-25');
  128. INSERT INTO tran VALUES(126,'Julia','Towar B',20,10,'2019-11-25');
  129. INSERT INTO tran VALUES(127,'Julia','Towar B',20,7,'2019-11-25');
  130. INSERT INTO tran VALUES(128,'Julia','Towar B',20,4,'2019-11-25');
  131. INSERT INTO tran VALUES(129,'Julian','Towar C',30,3,'2019-11-25');
  132. INSERT INTO tran VALUES(130,'Julian','Towar B',20,3,'2019-11-25');
  133. INSERT INTO tran VALUES(131,'Julian','Towar B',20,4,'2019-11-25');
  134. INSERT INTO tran VALUES(132,'Julian','Towar A',10,7,'2019-11-26');
  135. INSERT INTO tran VALUES(133,'Kamila','Towar B',20,5,'2019-11-25');
  136. INSERT INTO tran VALUES(134,'Kamila','Towar C',30,9,'2019-11-25');
  137. INSERT INTO tran VALUES(135,'Kamila','Towar C',30,9,'2019-11-25');
  138. INSERT INTO tran VALUES(136,'Kamila','Towar C',30,9,'2019-11-25');
  139. INSERT INTO tran VALUES(137,'Katarzyna','Towar B',20,9,'2019-11-25');
  140. INSERT INTO tran VALUES(138,'Katarzyna','Towar A',10,4,'2019-11-26');
  141. INSERT INTO tran VALUES(139,'Katarzyna','Towar B',20,9,'2019-11-25');
  142. INSERT INTO tran VALUES(140,'Katarzyna','Towar C',30,1,'2019-11-25');
  143. INSERT INTO tran VALUES(141,'Krystyna','Towar C',30,3,'2019-11-25');
  144. INSERT INTO tran VALUES(142,'Krystyna','Towar B',20,9,'2019-11-25');
  145. INSERT INTO tran VALUES(143,'Krystyna','Towar B',20,8,'2019-11-25');
  146. INSERT INTO tran VALUES(144,'Krystyna','Towar B',20,10,'2019-11-25');
  147. INSERT INTO tran VALUES(145,'Krzysztof','Towar B',20,10,'2019-11-25');
  148. INSERT INTO tran VALUES(146,'Krzysztof','Towar C',30,8,'2019-11-25');
  149. INSERT INTO tran VALUES(147,'Krzysztof','Towar B',20,4,'2019-11-25');
  150. INSERT INTO tran VALUES(148,'Krzysztof','Towar B',20,9,'2019-11-25');
  151. INSERT INTO tran VALUES(149,'Leon','Towar B',20,5,'2019-11-25');
  152. INSERT INTO tran VALUES(150,'Leon','Towar B',20,5,'2019-11-25');
  153. INSERT INTO tran VALUES(151,'Leon','Towar A',10,8,'2019-11-26');
  154. INSERT INTO tran VALUES(152,'Leon','Towar B',20,2,'2019-11-25');
  155. INSERT INTO tran VALUES(153,'Lilianna','Towar B',20,11,'2019-11-25');
  156. INSERT INTO tran VALUES(154,'Lilianna','Towar B',20,3,'2019-11-25');
  157. INSERT INTO tran VALUES(155,'Lilianna','Towar C',30,7,'2019-11-25');
  158. INSERT INTO tran VALUES(156,'Lilianna','Towar A',10,10,'2019-11-26');
  159. INSERT INTO tran VALUES(157,'Lucyna','Towar B',20,3,'2019-11-25');
  160. INSERT INTO tran VALUES(158,'Lucyna','Towar B',20,2,'2019-11-25');
  161. INSERT INTO tran VALUES(159,'Lucyna','Towar A',10,4,'2019-11-26');
  162. INSERT INTO tran VALUES(160,'Lucyna','Towar A',10,8,'2019-11-26');
  163. INSERT INTO tran VALUES(161,'Maciej','Towar A',10,6,'2019-11-26');
  164. INSERT INTO tran VALUES(162,'Maciej','Towar A',10,6,'2019-11-26');
  165. INSERT INTO tran VALUES(163,'Maciej','Towar B',20,4,'2019-11-25');
  166. INSERT INTO tran VALUES(164,'Maciej','Towar B',20,2,'2019-11-25');
  167. INSERT INTO tran VALUES(165,'Magdalena','Towar B',20,1,'2019-11-25');
  168. INSERT INTO tran VALUES(166,'Magdalena','Towar B',20,10,'2019-11-25');
  169. INSERT INTO tran VALUES(167,'Magdalena','Towar B',20,4,'2019-11-25');
  170. INSERT INTO tran VALUES(168,'Magdalena','Towar A',10,7,'2019-11-26');
  171. INSERT INTO tran VALUES(169,'Maksymilian','Towar B',20,6,'2019-11-25');
  172. INSERT INTO tran VALUES(170,'Maksymilian','Towar A',10,8,'2019-11-26');
  173. INSERT INTO tran VALUES(171,'Maksymilian','Towar B',20,6,'2019-11-25');
  174. INSERT INTO tran VALUES(172,'Maksymilian','Towar B',20,7,'2019-11-25');
  175. INSERT INTO tran VALUES(173,'Marcin','Towar B',20,4,'2019-11-25');
  176. INSERT INTO tran VALUES(174,'Marcin','Towar C',30,2,'2019-11-25');
  177. INSERT INTO tran VALUES(175,'Marcin','Towar B',20,10,'2019-11-25');
  178. INSERT INTO tran VALUES(176,'Marcin','Towar B',20,8,'2019-11-25');
  179. INSERT INTO tran VALUES(177,'Marcjanna','Towar B',20,9,'2019-11-25');
  180. INSERT INTO tran VALUES(178,'Marcjanna','Towar B',20,11,'2019-11-25');
  181. INSERT INTO tran VALUES(179,'Marcjanna','Towar A',10,9,'2019-11-26');
  182. INSERT INTO tran VALUES(180,'Marcjanna','Towar B',20,10,'2019-11-25');
  183. INSERT INTO tran VALUES(181,'Maria','Towar A',10,4,'2019-11-26');
  184. INSERT INTO tran VALUES(182,'Maria','Towar A',10,6,'2019-11-26');
  185. INSERT INTO tran VALUES(183,'Maria','Towar B',20,1,'2019-11-25');
  186. INSERT INTO tran VALUES(184,'Maria','Towar A',10,6,'2019-11-26');
  187. INSERT INTO tran VALUES(185,'Marika','Towar B',20,1,'2019-11-25');
  188. INSERT INTO tran VALUES(186,'Marika','Towar A',10,4,'2019-11-26');
  189. INSERT INTO tran VALUES(187,'Marika','Towar A',10,6,'2019-11-26');
  190. INSERT INTO tran VALUES(188,'Marika','Towar C',30,5,'2019-11-25');
  191. INSERT INTO tran VALUES(189,'Martyna','Towar B',20,10,'2019-11-25');
  192. INSERT INTO tran VALUES(190,'Martyna','Towar A',10,5,'2019-11-26');
  193. INSERT INTO tran VALUES(191,'Martyna','Towar C',30,4,'2019-11-25');
  194. INSERT INTO tran VALUES(192,'Martyna','Towar B',20,5,'2019-11-25');
  195. INSERT INTO tran VALUES(193,'Marzena','Towar C',30,6,'2019-11-25');
  196. INSERT INTO tran VALUES(194,'Marzena','Towar A',10,3,'2019-11-26');
  197. INSERT INTO tran VALUES(195,'Marzena','Towar A',10,3,'2019-11-26');
  198. INSERT INTO tran VALUES(196,'Marzena','Towar B',20,8,'2019-11-25');
  199. INSERT INTO tran VALUES(197,'Mirella','Towar C',30,11,'2019-11-25');
  200. INSERT INTO tran VALUES(198,'Mirella','Towar C',30,7,'2019-11-25');
  201. INSERT INTO tran VALUES(199,'Mirella','Towar B',20,5,'2019-11-25');
  202. INSERT INTO tran VALUES(200,'Mirella','Towar A',10,6,'2019-11-26');
  203. INSERT INTO tran VALUES(201,'Natan','Towar C',30,10,'2019-11-25');
  204. INSERT INTO tran VALUES(202,'Natan','Towar C',30,1,'2019-11-25');
  205. INSERT INTO tran VALUES(203,'Natan','Towar C',30,10,'2019-11-25');
  206. INSERT INTO tran VALUES(204,'Natan','Towar A',10,8,'2019-11-26');
  207. INSERT INTO tran VALUES(205,'Nikola','Towar B',20,2,'2019-11-25');
  208. INSERT INTO tran VALUES(206,'Nikola','Towar C',30,7,'2019-11-25');
  209. INSERT INTO tran VALUES(207,'Nikola','Towar B',20,4,'2019-11-25');
  210. INSERT INTO tran VALUES(208,'Nikola','Towar B',20,11,'2019-11-25');
  211. INSERT INTO tran VALUES(209,'Odetta','Towar C',30,9,'2019-11-25');
  212. INSERT INTO tran VALUES(210,'Odetta','Towar B',20,3,'2019-11-25');
  213. INSERT INTO tran VALUES(211,'Odetta','Towar A',10,2,'2019-11-26');
  214. INSERT INTO tran VALUES(212,'Odetta','Towar A',10,7,'2019-11-26');
  215. INSERT INTO tran VALUES(213,'Pamela','Towar A',10,7,'2019-11-26');
  216. INSERT INTO tran VALUES(214,'Pamela','Towar C',30,1,'2019-11-25');
  217. INSERT INTO tran VALUES(215,'Pamela','Towar A',10,8,'2019-11-26');
  218. INSERT INTO tran VALUES(216,'Pamela','Towar B',20,9,'2019-11-25');
  219. INSERT INTO tran VALUES(217,'Paweł','Towar A',10,3,'2019-11-26');
  220. INSERT INTO tran VALUES(218,'Paweł','Towar B',20,10,'2019-11-25');
  221. INSERT INTO tran VALUES(219,'Paweł','Towar B',20,1,'2019-11-25');
  222. INSERT INTO tran VALUES(220,'Paweł','Towar A',10,9,'2019-11-26');
  223. INSERT INTO tran VALUES(221,'Petronella','Towar C',30,5,'2019-11-25');
  224. INSERT INTO tran VALUES(222,'Petronella','Towar C',30,2,'2019-11-25');
  225. INSERT INTO tran VALUES(223,'Petronella','Towar B',20,5,'2019-11-25');
  226. INSERT INTO tran VALUES(224,'Petronella','Towar B',20,5,'2019-11-25');
  227. INSERT INTO tran VALUES(225,'Piotr','Towar B',20,6,'2019-11-25');
  228. INSERT INTO tran VALUES(226,'Piotr','Towar B',20,3,'2019-11-25');
  229. INSERT INTO tran VALUES(227,'Piotr','Towar B',20,10,'2019-11-25');
  230. INSERT INTO tran VALUES(228,'Piotr','Towar B',20,2,'2019-11-25');
  231. INSERT INTO tran VALUES(229,'Sławomir','Towar B',20,7,'2019-11-25');
  232. INSERT INTO tran VALUES(230,'Sławomir','Towar C',30,3,'2019-11-25');
  233. INSERT INTO tran VALUES(231,'Sławomir','Towar C',30,9,'2019-11-25');
  234. INSERT INTO tran VALUES(232,'Sławomir','Towar B',20,9,'2019-11-25');
  235. INSERT INTO tran VALUES(233,'Stanisław','Towar A',10,2,'2019-11-26');
  236. INSERT INTO tran VALUES(234,'Stanisław','Towar B',20,10,'2019-11-25');
  237. INSERT INTO tran VALUES(235,'Stanisław','Towar B',20,11,'2019-11-25');
  238. INSERT INTO tran VALUES(236,'Stanisław','Towar B',20,7,'2019-11-25');
  239. INSERT INTO tran VALUES(237,'Sylwia','Towar C',30,8,'2019-11-25');
  240. INSERT INTO tran VALUES(238,'Sylwia','Towar C',30,5,'2019-11-25');
  241. INSERT INTO tran VALUES(239,'Sylwia','Towar B',20,4,'2019-11-25');
  242. INSERT INTO tran VALUES(240,'Sylwia','Towar C',30,7,'2019-11-25');
  243. INSERT INTO tran VALUES(241,'Szymon','Towar C',30,9,'2019-11-25');
  244. INSERT INTO tran VALUES(242,'Szymon','Towar B',20,4,'2019-11-25');
  245. INSERT INTO tran VALUES(243,'Szymon','Towar B',20,10,'2019-11-25');
  246. INSERT INTO tran VALUES(244,'Szymon','Towar C',30,2,'2019-11-25');
  247. INSERT INTO tran VALUES(245,'Teresa','Towar B',20,9,'2019-11-25');
  248. INSERT INTO tran VALUES(246,'Teresa','Towar C',30,8,'2019-11-25');
  249. INSERT INTO tran VALUES(247,'Teresa','Towar C',30,11,'2019-11-25');
  250. INSERT INTO tran VALUES(248,'Teresa','Towar C',30,1,'2019-11-25');
  251. INSERT INTO tran VALUES(249,'Wiliam','Towar B',20,2,'2019-11-25');
  252. INSERT INTO tran VALUES(250,'Wiliam','Towar B',20,4,'2019-11-25');
  253. INSERT INTO tran VALUES(251,'Wiliam','Towar C',30,10,'2019-11-25');
  254. INSERT INTO tran VALUES(252,'Wiliam','Towar B',20,2,'2019-11-25');
  255. INSERT INTO tran VALUES(253,'Wincenty','Towar B',20,10,'2019-11-25');
  256. INSERT INTO tran VALUES(254,'Wincenty','Towar C',30,9,'2019-11-25');
  257. INSERT INTO tran VALUES(255,'Wincenty','Towar B',20,6,'2019-11-25');
  258. INSERT INTO tran VALUES(256,'Wincenty','Towar B',20,2,'2019-11-25');
  259. INSERT INTO tran VALUES(257,'Wioleta','Towar B',20,6,'2019-11-25');
  260. INSERT INTO tran VALUES(258,'Wioleta','Towar B',20,11,'2019-11-25');
  261. INSERT INTO tran VALUES(259,'Wioleta','Towar B',20,1,'2019-11-25');
  262. INSERT INTO tran VALUES(260,'Wioleta','Towar A',10,9,'2019-11-26');
  263. INSERT INTO tran VALUES(261,'Wojciech','Towar A',10,6,'2019-11-26');
  264. INSERT INTO tran VALUES(262,'Wojciech','Towar B',20,9,'2019-11-25');
  265. INSERT INTO tran VALUES(263,'Wojciech','Towar B',20,10,'2019-11-25');
  266. INSERT INTO tran VALUES(264,'Wojciech','Towar B',20,8,'2019-11-25');
  267. INSERT INTO tran VALUES(265,'Zbigniew','Towar B',20,10,'2019-11-25');
  268. INSERT INTO tran VALUES(266,'Zbigniew','Towar C',30,3,'2019-11-25');
  269. INSERT INTO tran VALUES(267,'Zbigniew','Towar A',10,9,'2019-11-26');
  270. INSERT INTO tran VALUES(268,'Zbigniew','Towar B',20,8,'2019-11-25');
  271. INSERT INTO tran VALUES(269,'Zofia','Towar B',20,3,'2019-11-25');
  272. INSERT INTO tran VALUES(270,'Zofia','Towar A',10,4,'2019-11-26');
  273. INSERT INTO tran VALUES(271,'Zofia','Towar C',30,9,'2019-11-25');
  274. INSERT INTO tran VALUES(272,'Zofia','Towar C',30,7,'2019-11-25');
  275. INSERT INTO tran VALUES(273,'Zuzanna','Towar C',30,2,'2019-11-25');
  276. INSERT INTO tran VALUES(274,'Zuzanna','Towar B',20,10,'2019-11-25');
  277. INSERT INTO tran VALUES(275,'Zuzanna','Towar B',20,2,'2019-11-25');
  278. INSERT INTO tran VALUES(276,'Zuzanna','Towar B',20,7,'2019-11-25');
  279.  
  280. CREATE TABLE klienci(id_klienta int NOT NULL AUTO_INCREMENT PRIMARY KEY, imie varchar(50));
  281. CREATE TABLE towary(id_towaru int NOT NULL AUTO_INCREMENT PRIMARY KEY, nazwa varchar(50), cena int);
  282. CREATE TABLE faktury(id_faktury int NOT NULL AUTO_INCREMENT PRIMARY KEY, id_klienta int, data date);
  283. CREATE TABLE zamowienia(id_zamowienia int NOT NULL AUTO_INCREMENT PRIMARY KEY, id_towaru int, id_faktury int, sztuki int);
  284.  
  285. ALTER TABLE faktury
  286. ADD FOREIGN KEY (id_klienta) REFERENCES klienci(id_klienta);
  287.  
  288. ALTER TABLE zamowienia
  289. ADD FOREIGN KEY (id_faktury) REFERENCES faktury(id_faktury);
  290.  
  291. ALTER TABLE zamowienia
  292. ADD FOREIGN KEY (id_towaru) REFERENCES towary(id_towaru);
  293.  
  294. INSERT INTO towary(nazwa, cena) SELECT DISTINCT towar, cena from tran;
  295. INSERT INTO klienci(imie) SELECT DISTINCT imie from tran;
  296.  
  297.  
  298. //
  299. INSERT INTO zamowienia(nr_zamowienia, nr_klienta, sztuki) SELECT faktury.nr_zamowienia, klienci.nr_klienta, faktury.sztuki from faktury join klienci on faktury.imie = klienci.imie GROUP BY faktury.nr_zamowienia;
  300.  
  301. UPDATE z5_zamowienia
  302. JOIN z5_faktury ON z5_zamowienia.nr_zamowienia = z5_faktury.nr_zamowienia
  303. JOIN z5_towary ON z5_faktury.towar = z5_towary.nazwa
  304. SET z5_zamowienia.nr_towaru = z5_towary.nr_towaru;
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!