Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create table Spieler(
- vid varchar(50) not null,
- sid varchar(50) not null,
- sName varchar(50) not null,
- primary key(sid),
- );
- begin transaction;
- delete from Spieler;
- insert into Spieler(vid,sid,sName)
- values ('BYM' , 'MAK','Makaay');
- insert into Spieler (vid,sid,sName)
- values ('BYM' , 'SOL', 'Scholl');
- insert into Spieler(vid,sid,sName)
- values ('FCN' , 'BAO', 'Banovic');
- insert into Spieler(vid,sid,sName)
- values ('KAIS' , 'LOR', 'Lorsen');
- insert into Spieler(vid,sid,sName)
- values ('FCN' , 'MUL', 'Müller');
- commit;
- Select * from Spieler;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement