CODEWITHSUNDEEP
mysqltriggers
enfield
enfield

Reputation: 841

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, DateCreated, DateUpdated) 
     VALUES(New.PartyId, ’M’,now(), now());
END;
|

DELIMITER ;

Upvotes: 0

Views: 81

Answers (1)

mu is too short
mu is too short

Reputation: 434705

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());

Upvotes: 2

Related Questions