because batch update operations are always involved recently, I don"t know if batch operations can be performed, so we can only update, one by one in the loop
, so I"d like to ask whether there is a sql statement in the sql database that enables update to modify data in batches like insert.
for example:
account table account_info: id, name name, balance balance
INSERT INTO account_info(name,balance) values("",0),("",10),("",15)
does update have similar statements, for example, I have an array
[
{name: "", sum: 5},
{name: "", sum: -8},
{name: "", sum: -10}
]
The name corresponds to the amount one by one for one-time batch updates. Make the data in the database become
[
{id:1, name: "", balance: 5},
{id:2, name: "", balance: 2},
{id:3, name: "", balance: 5}
]
not sure if there is such a way. So ask a question.
if you know, you are welcome to reply.
if you don"t know, you can collect it, in case someone answers.