I have 10 tuples in my table.And now I create another field of serial number.For all tuples, the field of serial number contain null values.
is there any way to numbering all the tuples from 1 to 10 at once.

Any answer could be appreciated......

Recommended Answers

There no distinct field ?

Jump to Post

All 3 Replies

There no distinct field ?

Thank you for responding to my thread............

Yes, of course.But If I have more number of distinct tuples, it is somewhat difficult to identify each and every field.So I want "Is there any command to operate it?"

Here is another way for you to understand my question.....

I have 100 employees list with attributes name, id, salary. Now I want to create another field name serial number, in order to numbering them from 1 to 100; I should have to identify each one and then I will assign numbers.
But Is there any command which assigns numbers serially from 1 to cardinality.
( I listened about auto_increament, but I don't think so it is useful here)..

you can do that by running a script to update the records.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.