Answer the question
In order to leave comments, you need to log in
What does error 1064 mean in MySQL?
I'm trying to create a trigger. I think the essence of the trigger is clear
DELIMITER |
CREATE TRIGGER `setBusyForRoom` AFTER INSERT ON `accommodation` FOR EACH ROW
BEGIN
UPDATE TABLE `rooms`
SET `rooms`.`room_status` = 'Занят'
WHERE `rooms`.`id_room` = `accommodation`.`id_room`
END
DELIMITER ;
#1064 -
I have no idea what it means. If this is a syntax error, what am I doing wrong? DELIMITER
and without, put in different places ;
and all that room_status
this is ENUM()
with four text values
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question