mysql 触发器不存在_插入时mysql触发器,如果​​行不存在

我的触发器不起作用.

基本上,当创建user_briefcase时,我还想在user_complementary_info中创建一个行(如果它尚不存在),其中user_complementay.user_id =新创建的user_briefcase.user_id

我的触发器

DROP TRIGGER IF EXISTS complementary_user_info

DELIMITER $$

CREATE TRIGGER complementary_user_info AFTER INSERT user_briefcases FOR EACH ROW

BEGIN

IF (SELECT COUNT(*) user_complementary WHERE user_id=NEW.user_briefcases.user_id) = 0 THEN

INSERT INTO user_complementary (user_id)

VALUES (NEW.user_briefcases.user_id)

END $$

DELIMITER ;