mysql 保存 union_在MYSQL存儲過程中將UNION查詢的結果保存在局部變量中

In my MySQL Stoared Procedure I want to store result of bellow query into local variables.

在我的MySQL Stoared過程中，我想將波紋管查詢的結果存儲到局部變量中。

MySQL SP

MySQL SP

BEGIN

Declare temp_ID bigint;

Declare temp_teamName Text;

(select ID,team1 from tbl_tournament_matches where leveID = 1 and tournamentID = 91 and matchType = 'L')

UNION

(select ID,team1 from tbl_tournament_matches where leveID = 2 and tournamentID = 91 and looserTeam is not null)

ORDER BY RAND() LIMIT 0,1;

select temp_ID, temp_teamName;

END;

How can I pass result of query into local variable? note : above SP will return only 1 row.

如何將查詢結果傳遞給局部變量？注意：上面的SP只返回1行。

1 个解决方案

#1

3

You can achieve this without having to store the value into a variable.

您無需將值存儲到變量中即可實現此目的。

SELECT * FROM(

select ID,team1 from tbl_tournament_matches where leveID = 1 and tournamentID = 91 and matchType = 'L'

UNION

select ID,team1 from tbl_tournament_matches where leveID = 2 and tournamentID = 91 and looserTeam is not null

) ORDER BY RAND() LIMIT 0,1

But, if you want to store a value for later use, you can use the INTO keyword:

但是，如果要存儲值以供以后使用，可以使用INTO關鍵字：

SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1;

http://dev.mysql.com/doc/refman/5.0/en/select-into.html