Advertisement
Guest User

Trigger Pengurangan Jumlah Kursi

a guest
May 27th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.19 KB | None | 0 0
  1. CREATE TRIGGER `Pengurangan_Kursi` AFTER INSERT ON `penumpang`
  2.  FOR EACH ROW BEGIN
  3.     UPDATE jadwal SET jumlah_kursi=jumlah_kursi-NEW.jumlah_penumpang
  4.     WHERE id_jadwal=NEW.id_jadwal;
  5. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement