How to add incremental field to mysql output?

Question

MySQL

I don’t know how to call it correctly, but in general I need to display some data and that with each entry a field is displayed indicating its number. Like this:

row1: field1, field2, 1
row2: field1, field2, 2
...
rowN: field1, field2, N

That is, this data is not stored in tables, but generated during output. There seems to be some sort of procedure?

Answer 1

SET @id = 0;
;
SELECT 
    @id := @id+1,
    table.`field1`,
    table`field2`
FROM `table`