Postgresql连表更新字段语法update

2023年8月3日发(作者：)

Postgresql连表更新字段语法update下⾯这段sql本来⽬的是想更新条件下的数据，可是这段sql却更新了整个表的数据。sql如下：UPDATE tops__orderSET op_audit_abort_pass_date = now()FROM tops__order as t1INNER JOIN tops__visitor as t2

ON t1. ID = _idWHERE _audit_abort_pass_date IS NULLAND ( t2. STATE = 'pch_abort_op_audit_pass' OR t2. STATE = 'pvd_abort_op_audit_pass')

正确的写法有多种，如下⽅法也能够实现正确的数据库修改：

UPDATE tops__order as t1SET op_audit_abort_pass_date = now()FROM tops__visitor AS t2WHERE = _idAND _audit_abort_pass_date IS NULLAND ( t2. STATE = 'pch_abort_op_audit_pass' OR t2. STATE = 'pvd_abort_op_audit_pass')

2023年8月3日发(作者：)

Postgresql连表更新字段语法update下⾯这段sql本来⽬的是想更新条件下的数据，可是这段sql却更新了整个表的数据。sql如下：UPDATE tops__orderSET op_audit_abort_pass_date = now()FROM tops__order as t1INNER JOIN tops__visitor as t2

ON t1. ID = _idWHERE _audit_abort_pass_date IS NULLAND ( t2. STATE = 'pch_abort_op_audit_pass' OR t2. STATE = 'pvd_abort_op_audit_pass')

正确的写法有多种，如下⽅法也能够实现正确的数据库修改：

UPDATE tops__order as t1SET op_audit_abort_pass_date = now()FROM tops__visitor AS t2WHERE = _idAND _audit_abort_pass_date IS NULLAND ( t2. STATE = 'pch_abort_op_audit_pass' OR t2. STATE = 'pvd_abort_op_audit_pass')