人生苦短……
SELECT t.*, @RowNum := @RowNum + 1 AS RowNum FROM t, (SELECT @RowNum := 0) AS myRows
MySQL中没有ROW_NUMBER()函数,可以用以上代码替换。
Copyright @ 2024 张小刀 Powered by .NET 8.0 on Kubernetes Powered by: .Text and ASP.NET Theme by: .NET Monster