我有一张有两列a和b的桌子。
a | b
+----+----+
x | l
y | m
z | n使用单个mysql更新查询,我希望更新多行的列.
update tableName set b = l1,m1,n1 where a= x,y,z respectively.对此的更新查询应该是什么样子?
编辑我的问题,以便更清楚地说明:我不想在列值中追加1。我想把它们更新为新的价值观,而这些价值观不像旧的那样。那么,是否可以使用(一个MYSQL查询)来做到这一点呢?
基本上,我想将这些查询合并为一个:
update tableName set b=newVal, where a=something;
update tableName set b=anotherNewVal, where a=something_else;
update tableName set b=yetAnotherNewVal, where a=something_else_again;非常感谢!
发布于 2015-10-10 06:02:36
非常感谢你的帮助。@Giorgos Betsos,mynawaz和Mathew。我找到查询了!
update tableName
set b = case
when a ='x' then 'a is x'
when a ='y' then 'a is y'
else b
end;发布于 2015-10-09 07:04:58
尝尝这个
UPDATE tableName SET b = CONCAT(b, '1') WHERE a = 'x' OR a = 'y' OR a = 'z'或
UPDATE tableName SET b = CONCAT(b, '1') WHERE a IN ('x', 'y', 'z')发布于 2015-10-09 07:16:16
UPDATE `tableName`
SET `tableName`.`b`=
CASE
WHEN `tableName`.`b`='l' THEN 'l1'
WHEN `tableName`.`b`='m' THEN 'm1'
WHEN `tableName`.`b`='n' THEN 'n1'
END
WHERE `tableName`.`a` IN ('x','y','z');https://stackoverflow.com/questions/33031784
复制相似问题