Advertisement
Guest User

Untitled

a guest
Apr 26th, 2018
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. create table konta(id_konta int PRIMARY KEY not null auto_increment, login text(20), haslo text(20));
  2. create table uzytkownicy(id_uzytkownicy int PRIMARY KEY not null auto_increment, imie text(20), nazwisko text(20), adres text(20), telefon text(20));
  3. insert into uzytkownicy values(null,'Jan','Nowak','Warszawa, Kopernika 4','608111222');
  4. insert into konta values(null,'JanNowak','qwerty');
  5. select imie,nazwisko from uzytwkownicy;
  6. select adres from uzytkownicy where id_uzytkownicy=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement