1
I have a table where there are several records of supplies, now will be implemented a column in this table where will be saved a label that facilitates to find these supplies in the stock, I have already adjusted the table so that all new records when inserted into the table get a sequential number for these new records, but I need to add a label for the other supplies that have been added to the stock before. Is there any way to add a sequential number to multiple records with an SQL command?
Ever thought of an update? where the new field is null..
– wDrik
I think what you need, is incremental update, example: 1,2,3,4 etc, correct?
– Geilton Xavier Santos de Jesus
I believe that an incremental update really solves @Geiltonxavier, you can put an example in a reply?
– R.Santos
I’ll add an example as a response.
– Geilton Xavier Santos de Jesus