Table -> Mysql Bulk Update

[taranakiretreat]

Kia ora - my apologies for a really simplistic question!
I am trying to update a MYSQL table with changes made in a LowCoder table.
I see that table.changeSet provides an object which could be used for the MYSQL GUI bulk update function.
...but I'm not quite sure how that function is expecting the data to be presented, in order for it to be happy to use it.
The changeSet has the structure {rownumber: {columnName: new value}}
...what is the technique for adapting this for the Bulk Update function? No matter what I try, I can't seem to get it to what is required:( Or is the bulk update capability not intended to be used in this way?!

Many many thanks for your help with this - it is very much appreciated!
Best regards, Jamie

[FalkWolsky]

The Object, that you would need is a bit different. It is table.toUpdateRows
Then you can choose GUI Mode in your Data Query Editor and insert pretty much {{table.toUpdateRows}}

[FalkWolsky]

Mind the "Primary Key Column", which Lowcoder needs to identify in the database. This must be available in the table Component (but naturally you can hide this column - so users do not get confused...)

[FalkWolsky]

We think in this Demo here it is demonstrated good: https://app.lowcoder.cloud/apps/66bccb8972ed3d1d42a4510f/view_marketplace/a8fb507

[taranakiretreat]

Utterly awesome, thank you:)))