[SQL] how to set the value to the column

[DM]

Hi All,

I have a table test with columns name and value

test table
name
value

It has around 500 rows.

I added a new column id to the table,

Table test
id,
name,
value

I am not sure how to insert numbers to my column id (1-500).

Thanks