how to Copy value data with trigger in another table?

Question

hi i need help how to copy value data with another table if Tbl_Transaksi STATUS= IN copy in TBL_MASUK and if STATUS=OUT copy in TBL_KELUAR. i want to make with trigger. Thank You

Gokhul Varman · Answer

If you refer the link you can get a good understanding abut it:https://www.sqlservercentral.com/Forums/Topic1253573-1292-1.aspx

Manas Mohapatra · Answer

You can try like this: CREATE TRIGGER trig_UpdateValues ON Tbl_Transaksi AFTER INSERT AS DECLARE @var int SELECT @var = ( SELECT Status FROM Inserted) CASE @var WHEN 'IN' THEN THEN SELECT ColumnName FROM Tbl_Masuk WHEN 'OUT' THEN THEN SELECT ColumnName FROM Tbl_Keluar ELSE -- do something else END

Amrul NigthBlue · Answer

Stil confuse  im trying make in mysql with this code working CREATE TRIGGER `tambah` AFTER INSERT ON `transaksi` FOR EACH ROW IF NEW.keterangan = 'masuk' THEN INSERT INTO masuk (idtransaksi nama keterangan jumlah) VALUES (NEW.idtransaksi NEW.nama NEW.keterangan NEW.jumlah); ELSEIF NEW.keterangan = 'keluar' THEN INSERT INTO keluar (idtransaksi nama keterangan jumlah) VALUES (NEW.idtransaksi NEW.nama NEW.keterangan NEW.jumlah); END IF

Amrul NigthBlue · Answer

It does not working im trying code like this but it same not working CREATE TRIGGER LOG_Transaksi ON Transaksi AFTER INSERT AS BEGIN DECLARE @status varchar (50) SELECT @status = ( SELECT Status FROM Inserted) IF @status = 'IN' SELECT Kode_Barang Kode_Transaksi Nama_Barang Jumlah Tanggal Keterangan Mengetahui Diketahui FROM Tbl_Masuk ELSE IF @status = 'OUT' SELECT Kode_Barang Kode_Transaksi Nama_Barang Jumlah Tanggal Keterangan Mengetahui Diketahui FROM Tbl_Keluar END