选择递增的整数 [英] Select incremented integer

问题描述

我想知道是否可以从mysql表中选择递增的整数？如果有可能，我怎么能实现呢？

I want to know if it's possible to select incremented integer from mysql table? and if it does possible, how can I achieve that?

我的情况是，我有一堆数据，我需要做 INSERT INTO newtable ...从sometable中选择somefield 。但是， newtable 上有一个名为计数器的字段，我需要以增量整数表示，例如：

My case is, I have a bunch of data and I need to do INSERT INTO newtable ... SELECT somefield FROM sometable. However, there is one field on newtable called counter that I need it in incremented integer, eg:

row #1: counter=1
row #2: counter=2
row #3: counter=3
row #4: counter=4
row #5: counter=5
row #6: counter=6
... and so on...

我可以使用简单的PHP脚本来做到这一点，但我想尝试从mysql查询中完成所有操作。所以，你能告诉我是否有可能吗？

I can do this using simple php script, but I want to try to do it all from mysql query. So, can you guys tell me if it's possible?

推荐答案

试试这个：

INSERT INTO newTable(someField, counter)
SELECT a.someField, (@rank:=@rank+1) AS counter
  FROM sometable a INNER JOIN 
       (SELECT @rank :=0) b

这篇关于选择递增的整数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！