indexing a table

[pitter1]

Hi all,I have a column which i want to put inside ascending indices, that is, empty column which i want to enter 1,2,3,4.....[tble no. of rows] so this table:col1 | col2 | col3 ------------------- | a | b | c | d | e | fbecomes:col1 | col2 | col3 ------------------- 1 | a | b 2 | c | d 3 | e | fthnks,Ahron

[aspnetguy]

You need to make the first column your primary key then use auto_increment or identity (depending on what databse you are using) to have them automatically increment with each new record.