mysql批量修改多条
批量修改一个字段的:UPDATE emp SET NAME = CASE id WHEN 1 THEN '222222222' WHEN 11 THEN '333333333' WHEN 12 THEN '444444444' ENDWHERE id IN (1,11,12)批量修改多个字段的:UPDATE orderform SET user_name = CASE orderform_id