updating columns with a sequence number H2

Asked Nov 02 '18 at 11:29

Active Nov 02 '18 at 12:39

Viewed 236 times

I have a table with the columns:

Name   Number

Arun     Null
Kiran    Null
Varun    Null

I want to update the number with a sequence number from 1-3 so it will look like this:

Name,   Number

 Arun    1
Kiran    2
Varun    3

How can I do this in H2 db?

Use case is this. Lets say I will add 10 records to the table. In one scenario I will delete 7th row. Now 1st 6 rows will have number 1-6. Since I have deleted 7th row, total number of rows are now 9. and 8th row and 9th row will have numbers 9 and 10. I want to modify it in such a way, no matter which row gets deleted, numbers will be auto arranged.

edited Nov 02 '18 at 11:39

asked Nov 02 '18 at 11:29

Vilas

1,690
1
13
12

https://stackoverflow.com/questions/43137040/how-to-update-id-set-from-1 – YLG Nov 02 '18 at 11:35
Presumably, the results are arranged alphabetically – Strawberry Nov 02 '18 at 11:35
You may use AUTO INCREMENT with alter table in mysql if it is only giving sequence number to the column – YLG Nov 02 '18 at 11:36
I don't want to modify existing table. let me help with more info. – Vilas Nov 02 '18 at 11:37
You wouldn't normally *store* this kind of thing. – Strawberry Nov 02 '18 at 11:40
"...in such a way, no matter which row gets deleted, numbers will be auto arranged..." What for? Why do you need correlative numbers all the time? What's wrong with having holes in between? – The Impaler Nov 02 '18 at 14:11

updating columns with a sequence number H2

0 Answers0