如何在触发器MYSQL内将变量设置为存储过程的结果? [英] How to set a variable to the result of a stored procedure inside a Trigger MYSQL?
本文介绍了如何在触发器MYSQL内将变量设置为存储过程的结果?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在这里有一个小问题,我正在为数据库工作创建一个触发器,但是我不知道如何在触发器中使用存储过程,我想将过程的结果保存在变量中,然后稍后在IF比较器上使用该变量,这是我的代码:
I have a little problem here, I'm making a trigger for my DB work, but I don't know how to use a stored procedure inside a trigger, I want to save the result of the procedure in a variable and then use the variable later on an IF comparator, this is my code:
DELIMITER @
CREATE TRIGGER insert_players AFTER INSERT ON players FOR EACH ROW
BEGIN
DECLARE A varchar(50);
set A = CALL consult_sex(player_name); //I WANT SOMETHING LIKE THIS
IF A != FEMALE THEN
INSERT INTO males (id_player, player_fullname, player_celphone)
VALUES (new.id_player, concat(new.player_name, " ", new.player_lastname), new.player_phone);
END IF;
END;
@
有人可以帮助我解决这个疑问吗?太好了,谢谢.
Could someone help me with this doubt? Would be wonderfull, thanks.
推荐答案
让您的过程采用OUT
参数,例如
have your procedure take a OUT
parameter like
CREATE PROCEDURE consult_sex(player_name VARCHAR(20), OUT player_sex VARCHAR(10))
在您的过程SET
中,值
SET player_sex = <your query to get sex>
通过参数调用过程
call consult_sex(player_name, @out_value);
select @out_value;
这篇关于如何在触发器MYSQL内将变量设置为存储过程的结果?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文