Advertisement
Guest User

Untitled

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