Questions: mysql batch update

Continued question: I want to teach mysql batch update questions UPDATEtableSETsCASEidWHEN1THEN1WHEN3THEN2ENDWHEREidIN (1, 3) to update a field. if I update two or more fields at the same time, how can I write ------ solution ...... Updatetablesetfiel: how to update mysql in batches
UPDATE table
SET s = CASE id
WHEN 1 THEN '1'
WHEN 3 THEN '2'
END
WHERE id IN (1, 3)
Update a field and write it like this. how to update two or more fields at the same time?

------ Solution --------------------
The same ......

Update table set field_a = '', field_ B = '',......

The ''part of your code is replaced by the case when syntax.

If other fields still depend on a field, replace the same structure