更新时间:2023-11-27 23:30:28
查询前需要更改分隔符:
You need to change delimiter before the query:
delimiter //
CREATE TRIGGER check_date BEFORE INSERT on Event
FOR EACH ROW
BEGIN
IF new.date <= now() THEN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'Event cannot start in the past event cannot start now. Choose an ulterior date';
END IF;
END;//
delimiter ;
另外,在你 END
为事件(触发器)执行整个代码块之前结束你的 IF
语句
Also, end your IF
statement before you END
the entire block of code to execute for an event(trigger)