Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER `Pengurangan_Kursi` AFTER INSERT ON `penumpang`
- FOR EACH ROW BEGIN
- UPDATE jadwal SET jumlah_kursi=jumlah_kursi-NEW.jumlah_penumpang
- WHERE id_jadwal=NEW.id_jadwal;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement