sql - 更新一列的多行

Question

我正在尝试更新一列的多行，如下所示

update persons set salary = (select salary from persons where name = 'John Smith') + 20000;

在这里，如果 name 是 John Smith，我想将所有 persons 的 salary 增加 20000。但是我收到错误

ERROR:  more than one row returned by a subquery used as an expression
********** Error **********

ERROR: more than one row returned by a subquery used as an expression
SQL state: 21000

我正在使用 Postgresql。

Answer 1

试试这个:

UPDATE persons 
   SET salary = salary + 20000
WHERE name = 'John Smith';