如何在MySQL查询的输出中插入序列? [英] how to insert sequence in output of MySQL query?

问题描述

我在查询中的输出如下:

从表中选择*；
id |数据
---------
14 trp
52吨
56 hjt
76 djd

我需要遵循以下顺序:

id |数据|序列
------------
14 trp 1
52公吨2
56 hjt 3
76 djd 4

i have output in query as follows:

select * from table;
id | data
---------
14 trp
52 mtp
56 hjt
76 djd

and i need following with sequence:

id | data|sequence
------------
14 trp 1
52 mtp 2
56 hjt 3
76 djd 4

and this sequence should generate every time dynamically!!!

推荐答案

如果您在sql server中需要使用此序列，则可以将row_number用于mysql，没有与此等效的方法，但您可以解决以下问题:

if you need this in sql server, you can use row_number for mysql, there is no equivalent of this, but you have a work around:

SQL Server:
USE AdventureWorks2008R2;
GO
WITH OrderedOrders AS
(
    SELECT SalesOrderID, OrderDate,
    ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
    FROM Sales.SalesOrderHeader
)
SELECT *
FROM OrderedOrders
WHERE RowNumber BETWEEN 50 AND 60;

MySQL:
SELECT @i:=@i+1 AS iterator, t.* FROM tablename t,(SELECT @i:=0) foo

更多信息:

http://stackoverflow.com/questions/1895110/row-number-in-mysql [ ^ ]

more info:

http://stackoverflow.com/questions/1895110/row-number-in-mysql[^]

这篇关于如何在MySQL查询的输出中插入序列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！