Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update klienci set nazwisko ="Kowalska" where idklienta=4
- update ksiazki set cena=round (cena*1.1, 2)
- update ksiazki set cena=cena-10 order by cena desc limit 1
- update klienci set imie="Joanna", nazwisko ="Dostojewska" where idklienta=10
- update zamowienia set status="wyslano" where idzamowienia between 4 and 5
- insert into klienci values (null, "Franciszek", "Janowski", "Chorzów")
- inster into zamowienia (idzamowienia, data, status, idklienta, idksiazki) values (null, "2016-01-01", "oczekiwanie", tytul) VALUES
- insert into ksiazki (idksiazki, nazwiskoautora, tytul) values (null, "Grębosz", "Symfonia C++")
- insert into klienci values (null, "Marylin", "Monroe", "Los Angeles")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement