UPDATE 表名
SET 要修改的列名 = CASE 标识列
WHEN 标识列的值 THEN '要修改的值'
WHEN 标识列的值 THEN '要修改的值'
END
WHERE (标识列>=1 and 标识列<=3)
例如:要依据id值来修改datemessage表中列名为receivetime列的数据
如果该行id值为1,则将该行的receivetime值改成’2018-07-12 15:20:54’
如果该行id值为2,则将该行的receivetime值改成’2018-07-12 15:18:54’
如果该行id值为3,则将该行的receivetime值改成’2018-07-12 15:16:54’
UPDATE datemessage
SET receivetime = CASE id
WHEN 1 THEN '2018-07-12 15:20:54'
WHEN 2 THEN '2018-08-12 15:18:54'
WHEN 3 THEN '2018-09-12 15:16:54'
END
WHERE (id>=1 and id<=3)