Mysql传递变量

Question

这是我们当前的查询:

SELECT info.yearID, info.nameFirst, info.nameLast, info.HR
FROM (
SELECT a.yearID, a.nameFirst, a.nameLast, a.HR FROM (
SELECT @curRank := @curRank+1 as rank, i.nameFirst, i.nameLast, i.masterID, i.HR, i.yearID 
FROM (  SELECT (select @curRank := 0), m.nameFirst, b.yearID, m.nameLast, b.masterId, sum(b.HR) as HR
FROM master as m left join batting as b on b.masterID = m.masterID
WHERE b.yearID = 1882 group by b.masterID) 
as i ORDER BY i.HR desc
)a 
WHERE a.HR = (SELECT i.HR
FROM ( 
SELECT (select @curRank := 0), m.nameFirst, b.yearID, m.nameLast, b.masterId, sum(b.HR) as HR
FROM master as m left join batting as b on b.masterID = m.masterID
WHERE b.yearID = 1882 
group by b.masterID
) 
as i  ORDER BY i.HR desc limit 1)) as info ;

我们需要确保 1882 不是硬编码的，而是从 1871 到 2013。

我不是在寻找答案，只是在寻找正确方向的一点。

Answer 1

b.yearID = @yearVar

^^ 该 @ 符号将被解析，并且您处理 @curRank 的方式将类似。它是提供某种类型的动态值(value)的一种手段。