Notes

mysql> select * from urunler;
+----+-------+------+
| id | ad | stok |
+----+-------+------+
| 1 | Elma | 500 |
| 2 | Armut | 1000 |
+----+-------+------+
2 rows in set

mysql> select * from satis;
Empty set

mysql> insert into satis values (0, now(), 1, 150);
Query OK, 1 row affected

mysql> select * from satis;
+----+---------------------+-----------------+----------------+
| id | satis_tarihi | satilan_urun_id | satilan_miktar |
+----+---------------------+-----------------+----------------+
| 1 | 2016-10-14 09:31:46 | 1 | 150 |
+----+---------------------+-----------------+----------------+
1 row in set

mysql> select * from urunler;
+----+-------+------+
| id | ad | stok |
+----+-------+------+
| 1 | Elma | 350 |
| 2 | Armut | 1000 |
+----+-------+------+
2 rows in set

mysql> delete from satis where id = 1;
Query OK, 1 row affected

mysql> select * from urunler
-> ;
+----+-------+------+
| id | ad | stok |
+----+-------+------+
| 1 | Elma | 500 |
| 2 | Armut | 1000 |
+----+-------+------+
2 rows in set

mysql>








create table urunler
(
id int primary key auto_increment,
ad varchar(50),
stok int
);

insert into urunler values (0,'Elma',500);
insert into urunler values (0,'Armut',1000);

select * from urunler;

create table satis
(
id int primary key auto_increment,
satis_tarihi datetime,
satilan_urun_id int,
satilan_miktar INT
);

-- satis tablosuna kayit eklendikten sonra
-- calisacak trig_satis_yap triggerini tanimla
create trigger trig_satis_yap
after insert on satis
for each row
BEGIN

update urunler set stok = stok - new.satilan_miktar
where id = new.satilan_urun_id;

end;

-- satis tablosunda kayit silindikten sonra
-- calisacak trig_satis_iptal triggerini tanimla
create trigger trig_satis_iptal after delete on satis
for each row
BEGIN
update urunler set stok = stok + old.satilan_miktar
where id = old.satilan_urun_id;

end;




-- trigger ile loglama

-- log tablosunu olustur
create table kisiler_logs (islem varchar(50), tarih datetime, aciklama varchar(255));


create trigger trig_kisi_ekle
after insert on kisiler
for each row
BEGIN

insert into kisiler_logs values ('INSERT', now(), concat(new.ad,' ',new.soyad,' isimli kayit eklendi') );

end;