Wyświetlono tabele.

Wyświetlono inserty pierwsze.

Wyświetlono tabele.

Wyświetlono inserty drugie.

Wyświetlono tabele.

Wyświetlono inserty trzecie.

Wyświetlono tabele.

Wyświetlono inserty czwarte.

Wyświetlono tabele.

Wyświetlono inserty piąte.

Utworzono inserty.

Kod SQL

            INSERT INTO gatunek_KG VALUES(1,"Powieść historyczna"),(2,"Powieść high fantasy"),(3,"Powiastka filozoficzna"),
            (4,"Powieść fantasy"),(5,"Powieść kryminalna"),(6,"Powieść science-fiction"),(7,"Powieść sensacyjna"),
            (8,"Poradnik psychologiczny"),(9,"Realizm magiczny"),(10,"Romans"),(11,"Tragikomedia"),
            (12,"Praca naukowa"),(13,"Powieść dziecięca"),(14,"Nowela"),(15,"Powieść erotyczna"),(16,"Powieść gotycka"),
            (17,"Horror"),(18,"Thriller"),(19,"Autobiografia"),(20,"Melodramat"); 

            INSERT INTO autor_KG VALUES(1,"Karol","Dickens","Mezczyzna"),(2,"J.R.R.","Tolkien","Mezczyzna"),(3,"Antoine","de Saint-Exupéry","Mezczyzna"),
            (4,"J.K.","Rowling","Kobieta"),(5,"Agatha","Christie","Kobieta"),(6,"H. Rider","Haggard","Mezczyzna"),(7,"Dan","Brown","Mezczyzna"),(8,"Napoleon","Hill","Mezczyzna"),
            (9,"Gabriel","García Márquez","Kobieta"),(10,"Vladimir","Nabokov","Mezczyzna"),(11,"Paulo","Coelho","Mezczyzna"),(12,"Shere","Hite","Kobieta"),
            (13,"Lucy Maud","Montgomery","Kobieta"),(14,"Richard","Bach","Mezczyzna"),(15,"E.L. ","James","Mezczyzna"),(16,"V.C.","Andrews","Mezczyzna"),
            (17,"Harper","Lee","Kobieta"),(18,"Wayne W.","Dyer","Mezczyzna"),(19,"Anne ","Frank","Kobieta"),(20,"F. Scott","Fitzgerald","Mezczyzna");

            INSERT INTO uczen_KG VALUES(1,"Jan","Kowalski",574637283,"Poznań"),(2,"Adam","Popielak",123827382,"Gniezno"),
            (3,\"Igor\",\"Moniszewski\",123218392,\"Łódź\"),(4,"Jakub","Antonowicz","Warszawa",132736289),
            (5,"Urszula","Mikowska",183728172,"Łódź"),(6,"Karolina","Maj",137283726,"Warszawa"),
            (7,"Olga","Przybylska",138291743,"Gniezno"),(8,"Amelia","Królewska",137281923,"Łódź"),
            (9,"Amelia","Kuliberda",138291023,"Gdańsk"),(10,"Janusz","Markoń",137283721,"Poznań"),
            (11,"Patryk","Wyrostek",183728392,"Białystok"),(12,"Krzysztof","Lipiec",183927163,"Kraków"),
            (13,"Monika","Matrymonialna",138273921,"Rzeszów"),(14,"Czesław","Tupolski",372819283,"Białystok"),
            (15,"Czesław","Wysocki",138372910,"Gdynia"),(16,"Damian","Apostolski",137281923,"Warszawa"),
            (17,"Paweł","Witek",183729102,"Rzym"),(18,"Dariusz ","Jażdrzyk",373920192,"Poznań"),
            (19,"Jacek","Tysarczyk",382372912,"Września"),(20,"Monika","Murawska",123726382,"Kraków");

            INSERT INTO ksiazki_KG VALUES(1,1,1,"Opowieść o dwóch miastach	",458,"B.dobry"),
            (2,2,2,"Władca Pierścieni",670,"B.dobry"),(3,3,3,"Mały Książę",290,"Dobry"),
            (4,4,4,"Harry Potter i Kamień Filozoficzny",560,"B.dobry"),(5,5,5,"I nie było już nikogo",400,"Średni"),
            (6,6,6,"Sen czerwonego pawilonu",300,"Zadawalający"),(7,7,7,"Ona: czyli historia niezwykłej wyprawy",320,"Dobry"),
            (8,8,8,"Kod Leonarda da Vinci",430,"Średni"),(9,9,9,"Buszujący w zbożu",539,"B.Dobry"),
            (10,10,10,"Alchemik",392,"Dobry"),(11,11,11,"Sto lat samotności",894,"Średni"),
            (12,12,12,"Pajęczyna Szarloty",364,"B.dobry"),(13,13,13,"Lolita",457,"Zły"),
            (14,14,14,"Czarny Książę",450,"Średni"),(15,15,15,"Ania z Zielonego Wzgórza",372,"B.dobry"),
            (16,16,16,"Orzeł wylądował",328,"Średni"),(17,17,17,"Wodnikowe Wzgórze",430,"Średni"),
            (18,18,18,"Mewa",382,"Dobry"),(19,19,19,"Anioły i demony",320,"Dobry"),
            (20,20,20,"Kane i Abel",310,"Średni");

            INSERT INTO wypozyczenia_KG VALUES(1,10,2,"2022-01-20",NULL,FALSE),(2,8,10,"2022-08-29","2022-09-10",TRUE),
            (3,12,19,"2022-05-08","2022-06-23",TRUE),(4,12,1,"2022-06-18","2022-05-02",TRUE),
            (5,1,20,"2022-04-30","2022-08-29",TRUE),(6,13,13,"2022-07-20",NULL,FALSE),(7,18,20,"2022-09-01","2022-09-10",TRUE)
            ,(8,12,2,"2022-08-19","2022-08-25",TRUE),(9,2,8,"2022-09-01","2022-09-10",TRUE),(10,19,4,"2022-06-18","2022-09-1",TRUE),
            (11,19,3,"2022-06-18","2022-09-1",TRUE),(12,19,5,"2022-06-18","2022-09-01",TRUE),
            (13,10,12,"2022-07-29",NULL,FALSE),(14,1,17,"2022-08-09","2022-09-08",TRUE),(15,1,12,"2022-09-02","2022-09-10",TRUE),
            (16,20,20,"2022-08-18","2022-08-20",TRUE),(17,19,4,"2022-09-18","2022-09-20",TRUE),
            (18,19,4,"2022-03-18","2022-03-29",TRUE),(19,9,15,"2022-06-18",NULL,FALSE),(20,1,10,"2022-08-17","2022-09-03",TRUE);