CODE EXAMPLE FOR SQL

mysql incrementation

SET @counter := 0;
SELECT
	col_name,
    @counter := @counter+1 as counter
FROM table_name