--Loo DB
create database transaktionSergachev;
use transaktionSergachev;

--loo tabel person
create table person (
	Id int not null primary key,
	name varchar(50) not null
)

--Lisa andmeid tabelisse
insert into person values(101,'Akash')
insert into person values(102,'Samir')

--Tee transaktion
begin transaction
insert into person values(103,'Hasan')

--Keeran muudatused tagasi
rollback;

--Teen transaksioon
begin transaction
update person set name='sima' where id = 103;

--Keeran muudatused tagasi 
rollback;

--Teen transaktsioon, kes kustuta andmeid tabelist Person kus id = 103

begin transaction
delete  from person where id=103;

--Ja salvesta seda
save transaction sav1
--sav1 on salvesta nime

begin transaction
insert into person values(104,'Hasan')
insert into person values(105,'Hasan')
insert into person values(106,'Hasan')
insert into person values(107,'Hasan')
save transaction sav2

select * from person

-- Keeran transaktsioon tagasi
rollback transaction sav1;