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
原创
2021-11-26 18:49:36 ·
1699 阅读 ·
0 评论