TEXT   52

inserts_2.txt

Guest on 23rd November 2021 09:55:51 PM

  1. insert into xx_jazyk values
  2. (1,'slovensky'),
  3. (2,'cesky'),
  4. (3,'anglicky'),
  5. (4,'nemecky'),
  6. (5,'francuzsky'),
  7. (6,'taliansky'),
  8. (7,'latinsky'),
  9. (8,'spanielsky');
  10.  
  11. insert into xx_autor values
  12. (1,'Umberto','Eco'),
  13. (2,'Lev','Bukovsky'),
  14. (3,'Jan','Vinar'),
  15. (4,'J.R.R.','Tolkien'),
  16. (5,'Jorge Luis','Borges'),
  17. (6,'Peter','Jaros'),
  18. (7,'Joseph','Heller'),
  19. (8,'Johann Valentin','Andreae'),
  20. (9,'Ubertino','De Casale'),
  21. (10,'Athanasius','Kircher'),
  22. (11,'Milos','Zahradnik'),
  23. (12,'Edsger','Dijkstra');
  24.  
  25. insert into xx_oddelenie values
  26. (1,'sucasna beletria'),
  27. (2,'informatika prakticka'),
  28. (3,'informatika teoreticka'),
  29. (4,'matematika'),
  30. (5,'filozofia vychodna'),
  31. (6,'filozofia zapadna'),
  32. (7,'nabozenstvo krestanske'),
  33. (8,'sci-fi a fantasy');
  34.  
  35. insert into xx_kategoria values
  36. (1,'student SS',30),
  37. (2,'student VS',90),
  38. (3,'zamestnanec VS',120),
  39. (4,'zamestnanec kniznice',180),
  40. (5,'root',3600);
  41.  
  42. insert into xx_mesto values
  43. (1,'Kosice','04012'),
  44. (2,'Bratislava','84545'),
  45. (3,'Banska Bystrica','97587'),
  46. (4,'Zilina','01001'),
  47. (5,'Presov','08001'),
  48. (6,'Poprad','05801'),
  49. (7,'Svidnik','08901'),
  50. (8,'Levoca','05401'),
  51. (9,'Trnava','91818'),
  52. (10,'Roznava','04801');
  53.  
  54. insert into xx_kniha values
  55. ( 1, 1,'Meno ruze',2000,1,1),
  56. ( 2, 1,'Il nome della rosa',1984,1,6),
  57. ( 3, 1,'Foucaultovo kyvadlo',1991,1,2),
  58. ( 4, 2,'Mnoziny a vselico okolo nich',1986,4,1),
  59. ( 5, 4,'Pan prstenov',2002,8,1),
  60. ( 6, 4,'Herr der Ringen',2001,8,4),
  61. ( 7, 5,'Alef',1949,1,8),
  62. ( 8, 6,'Tisicrocna vcela',1979,1,1),
  63. ( 9, 7,'Hlava XXII',2000,1,1),
  64. (10, 8,'Die Chymische Hochzeit des C. Rosenkreutz',1616,4,6),
  65. (11, 9,'Arbor vitae crucifixae Jesu Christi',1485,7,7),
  66. (12,10,'Mundus Subterranus',1665,7,6),
  67. (13,11,'Pestujeme linearni algebru',1999,2,4),
  68. (14,12,'Go To Considered Harmful',1968,3,3);
  69.  
  70. insert into xx_citatel values
  71. ( 1, 'Ali','Baba','Serail 35',10,'2002-04-01',1),
  72. ( 2, 'Peter','Vojtas','Jarnikova 1',1,'1990-03-25',3),
  73. ( 3, 'Lev','Bukovsky','Temna 5',1,'1995-08-16',3),
  74. ( 4, 'Pavol','Dubrava','Konvalinkova 7',7,'1999-12-24',1),
  75. ( 5, 'Emil','Kamzik','Gerlachovska 2655',8,'1998-8-8',2),
  76. ( 6, 'Jean','Carrefour','Slotova 15',4,'1993-1-1',2),
  77. ( 7, 'Khaled','Al-Himmat','Chwarizmiho 0',8,'2002-02-20',3),
  78. ( 8, 'Malachi','von Hildesheim','Krizova 1',1,'1960-01-01',4),
  79. ( 9, 'Berengar','de Arundel','Krizova 2',1,'1960-08-12',4),
  80. (10, 'Jorge','de Burgos','Finis Africae 1',1,'1950-01-01',5);
  81.  
  82.  
  83. insert into xx_vyprez values
  84. (1,3,'2001-02-28','v'),
  85. (3,6,'2002-01-05','r'),
  86. (4,10,'2002-04-11','v'),
  87. (5,10,'2000-03-02','v'),
  88. (6,3,'1979-05-05','r'),
  89. (8,6,'2001-12-12','r'),
  90. (9,3,'1998-10-15','v'),
  91. (10,7,'1996-08-15','r'),
  92. (11,9,'2002-03-01','v'),
  93. (12,10,'2002-01-03','v');
  94.  
  95. insert into xx_vrKnihy values
  96. (1, 7),
  97. (1, 4),
  98. (1, 13),
  99. (1, 14),
  100. (3, 11),
  101. (3, 2),
  102. (4, 9),
  103. (5, 5),
  104. (6, 11),
  105. (6, 7),
  106. (8, 8),
  107. (9, 2),
  108. (10, 7),
  109. (11, 1),
  110. (11, 3),
  111. (12, 5),
  112. (12, 6),
  113. (12, 7),
  114. (12, 12);

Raw Paste


Login or Register to edit or fork this paste. It's free.