Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. Create table Spieler(
  2. vid varchar(50) not null,
  3. sid varchar(50) not null,
  4. sName varchar(50) not null,
  5. primary key(sid),
  6. );
  7. begin transaction;
  8. delete from Spieler;
  9.  
  10. insert into Spieler(vid,sid,sName)
  11. values ('BYM' , 'MAK','Makaay');
  12. insert into Spieler (vid,sid,sName)
  13. values ('BYM' , 'SOL', 'Scholl');
  14. insert into Spieler(vid,sid,sName)
  15. values ('FCN' , 'BAO', 'Banovic');
  16. insert into Spieler(vid,sid,sName)
  17. values ('KAIS' , 'LOR', 'Lorsen');
  18. insert into Spieler(vid,sid,sName)
  19. values ('FCN' , 'MUL', 'Müller');
  20. commit;
  21. Select * from Spieler;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement