语法说明
UPDATE [ ONLY ]table
SETcolumn
= {expression
| DEFAULT } [, ...] [ FROMfromlist
] [ WHEREcondition
]
例子:
update table1 t1 set t1. name=t2.name from table2 t2 where t1.id=t2.id and t1.name is null;
语法说明
UPDATE [ ONLY ]table
SETcolumn
= {expression
| DEFAULT } [, ...] [ FROMfromlist
] [ WHEREcondition
]