How to execute batch query in mysql for update column values

Question

For example, I have a table ACCOUNT WITH TWO COLUMNS, ID AND A_NUMBER. AND I WANT TO UPDATE A_NUMBER VALUES IN A SINGLE APPLICATION WITH VARIOUS VALUES. "SET ACCOUNTING INSTRUCTIONS A_NUMBER =" 0135 "WHERE ID = 131; UPDATE ACCOUNT SET A_NUMBER =" 0145 "WHERE ID = 132; UPDATE ACCOUNT SET A_NUMBER =" 0155 "WHERE ID = 133; SET APPROVAL A_NUMBER =" 160 134; CHAIN ​​OF EXCHANGE OF ACCOUNTING A_NUMBER = "0175" WHERE ID = 135; UPDATE ACCOUNT SET A_NUMBER = "0180" WHERE ID = 136; SETTING UPDATE ACCOUNTS A_NUMBER = "0195" WHERE ID = 137; UPDATE ACCOUNT SET A 02NUMBER ID = 138; "

Answer 1

You should use the "CASE" Statment:

UPDATE tbl SET A_NUMBER = CASE
WHEN id = 1 THEN ‘0135’
WHEN id = 2 THEN ‘0175’
...
END
WHERE id IN (1,2,...)

I hope I helped