mysql 生成自增长序列

			select ttt.*,(@i:=@i+1) as i from (SELECT
					t2.country,
					t1.org,
				  count(DISTINCT t2.village) as villageNum,
					SUM(t1.desk_area_low_voltage_users) as accountNum
					FROM
					dc_cumulative_outage_list_detail t1
				INNER JOIN dc_desk_area_info t2 ON t1.desk_area_id = t2.desk_area_id
				INNER JOIN dc_cumulative_outage_list t3
				ON t1.cumulative_outage_list_id=t3.id
				WHERE
					t1.is_deleted = 0
				AND t2.is_deleted = 0
				AND (
					t1.type = 3
					or
					t1.type=2
					or
					(t1.type = 4
				 	AND t1.is_power_failure='是'))
			GROUP BY
			t2.country,t1.org) ttt,(SELECT @i:= 0) AS i