BEGIN
DECLARE msg varchar(200);
SET msg=(SELECT count(*) from fa_room_tag where target=NEW.target and targetid=NEW.targetid and deletetime is NULL );
IF msg >=1
THEN
SET msg=‘请勿重复添加’;
SIGNAL SQLSTATE ‘HY000’ SET MESSAGE_TEXT = msg;
END IF;
END
mysql添加触发器
最新推荐文章于 2024-07-18 04:04:28 发布