纯菜鸟求各位大神解救T T

[jyystc]

1 这个指针为什么不能用T T
DECLARE 计数游标 CURSOR
for SELECT city,`count`
FROM city.t_daochu_guoyeyou_day

OPEN 计数游标

DECLARE @city char(10)
DECLARE @count int
FETCH FIRST FROM 计数游标
INTO @city,@count
END

2 想了半天真的不知道语法错在哪了T T
SELECT t.`count`+count2,t.city,
STR_TO_DATE(concat(`year`,`month`,`day`),"%Y%m%d") AS `day1`
FROM city.t_daochu_guoyeyou_day t

INNER JOIN
(SELECT `count` AS count2,
STR_TO_DATE(concat(`year`,`month`,`day`+1),"%Y%m%d") aS day2,
city
FROM city.t_daochu_guoyeyou_day) t2
ON
((t.city=t2.city) AND (t.day1=t2.day2))
GROUP BY city

求解答！感激！！！！