SQL语句如下:
UPDATE 表1 a
SET a.gid = (select b.gid from 表2 b where b.cid = a.cid)
where exists (select 1
from 表2 b
where b.cid=a.cid
)
SQL语句如下:
UPDATE 表1 a
SET a.gid = (select b.gid from 表2 b where b.cid = a.cid)
where exists (select 1
from 表2 b
where b.cid=a.cid
)