同时修改这几个人的id
UPDATE sys_user
SET user_id =
CASE
user_id
WHEN '86' THEN
'301111'
WHEN '88' THEN
'301112'
WHEN '124' THEN
'301113'
WHEN '125' THEN
'301114'
END
WHERE
`name` IN ( '姜玲玲', '李瑞杰', '李全德', '王海滨')
同时修改这几个人的id
UPDATE sys_user
SET user_id =
CASE
user_id
WHEN '86' THEN
'301111'
WHEN '88' THEN
'301112'
WHEN '124' THEN
'301113'
WHEN '125' THEN
'301114'
END
WHERE
`name` IN ( '姜玲玲', '李瑞杰', '李全德', '王海滨')