Reputation: 23
please help me find the error on my trigger statement.
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;
Upvotes: 2
Views: 46
Reputation: 263883
delimiter
end if
try,
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 ;
Upvotes: 1