更新数据 upsert
upsert into (字段1,字段2,字段3,字段....)
select 字段1,字段2,字段3,字段....
from 库.表
where 条件
直接用Upsert Into Select就可以了
例:把tables表中cloumn2列等于bbb的都改成aaa
Upsert Into Table (cloumn1,cloumn2,cloumn3) Select Cloumn1,'aaa',Cloumn3 From Table where Cloumn2='bbb'