Tuesday, 20 September 2016
MENGURANGI STOK
CREATE TRIGGER PENGURANGAN after INSERT on tbl_barang_keluar
FOR EACH ROW BEGIN
UPDATE tbl_barang SET jumlah = jumlah - NEW.jumlah_beli
WHERE id_barang = NEW.id_barang;
END$$
(Delimeter : $$)
BATAL TRANSAKSI
CREATE TRIGGER BATAL after DELETE on tbl_barang_keluar
FOR EACH ROW BEGIN
UPDATE tbl_barang SET jumlah = jumlah + OLD.jumlah_beli
WHERE id_barang = OLD.id_barang ;
END$$
(Delimeter : $$)
MENAMBAH STOK
CREATE TRIGGER PENAMBAHAN after INSERT ON tbl_barang_masuk
FOR EACH ROW BEGIN
INSERT INTO tb_barang SET id_barang = NEW.id_ barang,
jumlah=NEW.jumlah_masuk
ON DUPLICATE KEY UPDATE jumlah=jumlah + New.jumlah_masuk ;
END$$
(Delimeter : $$)
Posts
