请帮我找到触发语句上的错误。
CREATE TRIGGER textmain_insert BEFORE INSERT ON textmain
FOR EACH ROW
BEGIN
IF NEW.text_create_datetime = '0000-00-00 00:00:00' THEN
SET NEW.text_create_datetime = NOW();
END IF
IF NEW.text_update_datetime = '0000-00-00 00:00:00' THEN
SET NEW.text_update_datetime = NOW();
END IF
END;
- 更改
delimiter
- 每次
end if
后终止
尝试
DELIMITER $$
CREATE TRIGGER textmain_insert BEFORE INSERT ON textmain
FOR EACH ROW
BEGIN
IF NEW.text_create_datetime = '0000-00-00 00:00:00' THEN
SET NEW.text_create_datetime = NOW();
END IF;
IF NEW.text_update_datetime = '0000-00-00 00:00:00' THEN
SET NEW.text_update_datetime = NOW();
END IF;
END $$
DELIMITER ;