SELECT * FROM (SELECT a.Bus_Name,(@rowNum:=@rowNum+1) as rowNo FROM a INNER JOIN (SELECT @rowNum:=-1)r) AS b WHERE b.Bus_Name = 'bus1';
MySQL 获取记录的行号
最新推荐文章于 2024-07-29 11:25:31 发布
SELECT * FROM (SELECT a.Bus_Name,(@rowNum:=@rowNum+1) as rowNo FROM a INNER JOIN (SELECT @rowNum:=-1)r) AS b WHERE b.Bus_Name = 'bus1';