Could someone please tell me what wrong with my syntax?
CREATE TRIGGER update_availableQTY_insert AFTER INSERT ON reservRooms FOR EACH ROW BEGIN UPDATE rooms SET rooms.availableQty = NEW.rooms.availableQty - 1 WHERE rooms.room_id = reservRooms.room_id
This one is also giving me an error:
CREATE TRIGGER update_availableQty_delete BEFORE DELETE ON reservRooms FOR EACH ROW BEGIN UPDATE rooms SET rooms.availableQty = OLD.rooms.availableQty + 1 WHERE rooms.room_id = reservRooms.room_id
I'm using version 5.0.45
Thanks,
Michael