mysql:
update A,B set A.c1= B.c1
where A.id = B.id
sqlserver:
update A SET A.c1=B.c1
from B
WHERE A.id = B.id
yangcclg 2016-05-24 09:12 原文
mysql:
update A,B set A.c1= B.c1
where A.id = B.id
sqlserver:
update A SET A.c1=B.c1
from B
WHERE A.id = B.id