Is it possible to batch update based on id?

I have a table with two columns id and position, I want to update the position based on the id, I am creating a list like this
[{id:1, position:0}, {id:3, position:1}, {id:2, position:2}]
[{id:1, position:0}, {id:3, position:1}, {id:2, position:2}]
And I want to update all records with the corresponding position, the only way I can think of is with an onConflict but for insert I need all the columns and I don't want to pass all that when the only data I need is id and position, is there a simpler way to do this?
0 Replies
No replies yetBe the first to reply to this messageJoin
Want results from more Discord servers?
Add your server