MySQL C 无法使用SET变量创建视图

发布时间：2023-12-20 06:25:52 所属栏目：MySql 来源：DaWei

导读： 我试图用SET @rank = 0创建一个视图;在里面,但它给了我错误.尝试过不同的东西,但它没有用.谁能指点我正确的方向？

CREATE VIEW S1_Bottom_Performer_AHT as (
SET @rank=0
SELECT @rank :=

我试图用SET @rank = 0创建一个视图;在里面,但它给了我错误.尝试过不同的东西,但它没有用.谁能指点我正确的方向？

CREATE VIEW S1_Bottom_Performer_AHT as ( SET @rank=0 SELECT @rank := @rank+1 AS '#',ei.SM,ei.TM,es.Month_Date,ei.emp_id,ei.DNAME,ei.STATUS,ei.SHIFT,ei.SKILL,ei.HIRE_DATE,ifnull(TIMESTAMPDIFF(MONTH,now()),'-') AS Tenure,ifnull(es.Call_Handled,'-') AS Call_Handled,ifnull(es.AHT,'-') AS AHT FROM mtl_extended_info ei LEFT OUTER JOIN ( SELECT es.Employee_ID,sum(es.Calls_Handled_Ct) AS Call_Handled,round((sum(es.I_Talk_Time_Sec) + sum(es.Hold_Time_Sec) + sum(es.I_Work_Time_Sec) + sum(es.I_AUX_Out_Time_Sec)) / sum(es.Calls_Handled_Ct)) AS AHT FROM cdl_agent_call_voume_gen es WHERE es.Month_Date = '2013-09-01' GROUP BY es.Employee_ID,es.Month_Date ) es ON es.Employee_ID = ei.emp_id WHERE es.Month_Date = '2013-09-01' AND ei.Visible = 1 AND ei.SKILL != 'RSD' GROUP BY ei.emp_id ORDER BY es.AHT DESC LIMIT 80);

错误信息：

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET @rank=0 SELECT @rank := @rank+1 AS '#',' at line 2 最佳答案我想你不能这样做.

从MYSQL guidelines开始：

A view definition is subject to the following restrictions:

[ deletia ]

The 07001 statement cannot refer to system or user variables.

（编辑：长春站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!