Hi,

I want to use a populate a table using a
INSERT ... [INTO] tbl_name [(col_name,...)]
SELECT ...
structure.

The thing here is that I want to have a order column, for example

register 4, 1, 234
register 45, 2, 834
register 54, 3, 5326
register 87, 4, 8753

the 2nd column (1, 2, 3, 4) has that order that I need and it´s not in the source table.

Any suggestions to do it?

Thanks.

One way to do this would be create an alias of your table, join the table to itself, and then add in a running count of matching records.

SELECT (SELECT COUNT(*) FROM myTable WHERE myTable.uniqueID < mt2.uniqueID)+1 AS INDX
FROM myTable INNER JOIN myTable AS mt2 ON myTable.uniqueID = mt2.uniqueID;

Note that the +1 is used to start the count with 1. You need to omit that if you want to start the count at 0.