mysql 查询时额外查询一个index列，类似sqlserver的ROW_NUMBER()

-- 创建临时表CREATE TEMPORARY TABLE temp1 AS ( SELECT (@rowindex := @rowindex +1) AS rowindex,a.city_id,b.name as 'city_name' ,a.dept_name,a.final_point FR
posted @ 2023-09-25 11:36  好记性不如烂笔头啊  阅读(35)  评论(0)  编辑  收藏  举报