Jump to content

indexing a table


pitter1
 Share

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...