mysql 1235,MySQL错误代码1235

In MySQL I tried to define a trigger like this:

DELIMITER $$

CREATE TRIGGER vipInvite

AFTER INSERT ON meetings

FOR EACH ROW

BEGIN

IF(NOT EXISTS (SELECT * FROM participants

WHERE meetid = NEW.meetid AND pid ='vip'))

THEN

IF(EXISTS(SELECT * FROM meetings WHERE meetid = NEW.meetid AND slot > 16))

THEN

INSERT INTO participants(meetid, pid)

VALUES (NEW.meetid,(SELECT userid

FROM people WHERE people.group = 'tap' GROUP BY invite));

END IF;

END IF;

END $$

DELIMITER ;

Produces this error:

This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table.

Is there a way to work around this so I can define multiple triggers?

解决方案

This error means you already have an AFTER INSERT trigger on meetings table.

If it is the same trigger (meaning vipInvite) that you created earlier and now you want to replace it then you need to drop it first

DROP TRIGGER vipInvite;

DELIMITER $$

CREATE TRIGGER vipInvite

...

END$$

DELIMITER ;

Now if you have some other trigger you have to merge code from both triggers into one, then drop existing trigger, and then create a new one.

To show the list of existing triggers use SHOW TRIGGERS.

SHOW TRIGGERS WHERE `table` = 'meetings';