SELECT @rowno:=@rowno + 1 AS rowno,a.* FROM tableName a,(SELECT @rowno:=0) b
转载于:https://www.cnblogs.com/BobXie85/p/8855037.html
SELECT @rowno:=@rowno + 1 AS rowno,a.* FROM tableName a,(SELECT @rowno:=0) b
转载于:https://www.cnblogs.com/BobXie85/p/8855037.html