mysql可以同时修改两张表,pgsql只能修改一张
mysql写法:
update table1 a,table2 b
set a.colA=a.colA+1
where a.id = b.id;
pgsql写法:
update table1 t set t.colA=t.colA+1
from table1 a inner join table2 b
on (a.id=b.id);
mysql可以同时修改两张表,pgsql只能修改一张
mysql写法:
update table1 a,table2 b
set a.colA=a.colA+1
where a.id = b.id;
pgsql写法:
update table1 t set t.colA=t.colA+1
from table1 a inner join table2 b
on (a.id=b.id);