-
mysql怎么给查询的记录编号
SELECT @rownum:=@rownum+1 AS rownum, tablename.*FROM (SELECT @rownum:=0) r, tablenameSELECTcity_name, title, COUNT(*
SELECT @rownum:=@rownum+1 AS rownum, tablename.*FROM (SELECT @rownum:=0) r, tablenameSELECTcity_name, title, COUNT(*