mysql批量更新和批量更新同一字段为不同值
1.MySQL更新一条记录语句:
UPDATE user SET name='zhangsan' WHERE id=1
2.更新同一条字段为相同值
UPDATE user SET name='zhangsan' WHERE id in (1,2,3);
3.更新不同记录为不同值(批量更新)
UPDATE user
SET name = CASE id
WHEN 1 THEN 'zhangsan'
WHEN 2 THEN 'lisi'
WHEN 3 THEN 'wangwu'
END
WHERE id in (1,2,3);