What's wrong with this MySQL trigger?
So what is wrong with this trigger? MySQL is only nice enough to tell me it is a 1064 error.
DELIMITER |
CREATE TRIGGER new_member BEFORE INSERT on member
FOR EACH ROW BEGIN
INSERT INTO party(PartyId, PartyTypeCode, DateCrea开发者_高级运维ted, DateUpdated)
VALUES(New.PartyId, ’M’,now(), now());
END;
|
DELIMITER ;
I'd guess that your problem is the non-ASCII quotes in your VALUES
:
VALUES(New.PartyId, ’M’,now(), now());
-- -----------------^
Try using plain old single quotes like SQL expects:
VALUES(New.PartyId, 'M', now(), now());
精彩评论