mysql怎么给查询的记录编号

SELECT @rownum:=@rownum+1 AS rownum, tablename.*

FROM (SELECT @rownum:=0) r, tablename

SELECT

city_name, title, COUNT(*)

FROM

tuan_info

GROUP BY city_name, title

HAVING COUNT(*) >1

---