mysql中初始化变量_MySql：在查询中初始化mySql变量

这是我的

MySql查询执行的序列：

查询1：SET @channel_rank = 0;

查询2：

SELECT time_of_day, @channel_rank := IF(

@current_channel = channel,

1,

@channel_rank + 1

) AS channel_rank ,

@current_channel := channel AS channel,Views

FROM

(

SELECT @channel_rank = 0,time_of_day,channel, SUM(Views) AS 'Views'

FROM access_logs_meaningful_optimized

WHERE `time_of_day` = 0

AND playing_date = '2016-10-26' GROUP BY channel

ORDER BY SUM(views) DESC

LIMIT 5

) xx;

样本结果：

time_of_day channel_rank channel Views

----------- ------------ --------------------- --------

0 1 Tolo 1291

0 2 Tolo News 855

0 3 Samaa News 805

0 4 Ary Digital 695

0 5 Dunya News 653

在这里我必须执行SET @channel_rank = 0;首先,为了将变量(@channel_rank)赋值为0.我的问题是如何,在查询2中我可以将变量(@channel_rank)分配给0,最初使第二个查询独立于第一个查询.