mysql-workbench - 行号分区mysql工作台

Question

这有什么问题

select 
ID
,SYSCODE
,LID
,ROW_NUMBER() OVER(PARTITION BY ID ORDER BY SYSCODE, LID) AS row_num
 from prod_sys.P_ENTERPRISE

它适用于管理工作室，但不适用于 mysql 工作台

标签： mysql-workbench

Answer 1

MYSQL 中没有 ROW_NUMBER()，请重写如下查询。

select 
ID
,SYSCODE
,LID
,@row_num := @row_num + 1 as Row_number
 from prod_sys.P_ENTERPRISE join (SELECT @row_num := 0) a;