摘要: SELECT `table`.*, (@rownum := @rownum + 1) AS ROWNUMFROM `table` inner join (SELECT @rownum := 0) rWHERE 1ORDER BY `table`.id; 阅读全文
posted @ 2015-04-22 12:12 根号五 阅读(567) 评论(0) 推荐(0) 编辑